AD 97-01-13
Registered aircraft · 54,837
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N2735KCook Kyle R · Green Valley, AZN2735QRegistration Pending · Hearne, TXRegistration pendingN2735UKnepper Gary E · Canby, ORN2736GFor Skies Flying Club Ltd · Martinsville, ILN2736KP M Logistics LLC · Haskell, OKN2736LWilson Steven W · N Richlnd Hls, TXFirst renewal noticeN2736QBachich George A · Napa, CAN2736XMehling Michael R · Fairview, MTN2737JClair Brent · Loraine, ILN2737KFanazick Joseph P · Juneau, AKN2737LAviation Trust Co LLC Trustee · Oklahoma City, OKN2737SBlock Oliver L · Nashville, TNN2737XFly-By Aviation Services LLC · Colorado Springs, CON2738BSonrise Aviation LLC · Portland, INN2738LDemkiewicz Daniel · Houston, TXN2738UVan Der Waal Allan L · Port Angeles, WAN2739CLge Flying Club Inc · Marietta, GAN2739GSwanson Gordon · Prescott, AZN2739JCiulla Santo · Odessa, FLN2739LHall Barbara S · Burgettstown, PAN2739UN2739u Holding LLC · New Orleans, LAN2739XSvoboda Realty Inc · Bucyrus, KSFirst renewal noticeN273EBNorth Country Aircraft Holdings LLC · Watertown, NYN273HPCalifornia Highway Patrol · Sacramento, CAN273JFParrish Aviation Flight Academy LLC · Southlake, TXN273TYRaven Aviation LLC · Lexington, KYN2740LLightsey Aviation LLC · Jacksonville, FLN2740TKraybill Paul D · Portola Valley, CAN2740UHarowicz Richard J · Mountain Top, PAN2740VTheo Enterprises LLC · New Castle, DEN2741UNickel Aviation LLC · Williamstown, NJN2742HWilbert John W III · Plaquemine, LAN2742LFisher Corey · Ardmore, OKN2742QKibler James · Indialantic, FLN2742UPembroke Farm LLC · Conowingo, MDN2742XCallaway Scott T · Soldotna, AKN2743FRiddle Danny M Trustee · Ruby Valley, NVN2743GFleetwood Jack · Hutto, TXN2743LBarnes Earl E · Live Oak, FLN2743QSzigeti David J · Gaylordsville, CTN2743UArmstrong John Kyle · Lovington, NMN2743XErb Weston Scott Trustee · Wasilla, AKN2744CBrewer Farms · Thompson, MON2744FTyson Jacob N · Molena, GAN2744GShelton Jeffrey A · Denali Park, AKN2744JOvation Cwa LLC · Prairie Du Sac, WIN2744KLucas Greg C · Elmore City, OKN2744PTouchdown LLC · Pls Vrds Est, CAN2744UFladager Daryl W · Peerless, MTN2744XAccelerated Slipstream LLC · Livermore, CA
Back to AD 97-01-13