AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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.
N277MMSolan Richard J · Canaan, CTN277MRSchab Davis Margaret A · Spangle, WAN277MTException LLC · Manning, SCN277MWEuroaviation Inc Trustee · KemN277PDControlthings LLC · Hurricane, UTN277PMRuley Paul B · West Lafayette, INN277RBWaldo Pepper Flying Co · Wilmington, DEN277RDWestline Corp · Medina, OHN277RKD O Aviation LLC · Wilmington, DEN277RMSoutheast Design & Manufacturing LLC · Sun City Center, FLN277SAFox Matthew C · Athlone WestheathNon-citizen corporation, flight hours not reportedN277SLCharlies Wings LLC · Salisbury, NCN277SMKroha Michael D · Southbury, CTN277SSStone Scott · Hot Springs, ARN277TVon Linsowe David J · Vero Beach, FLN277TCTranslift Inc · Holly, MIN277TMPollock Donald Edward · Union Hall, VAN277WWithnell Kurt W · Laguna Niguel, CAN277WLLozier Wesley · Farmington, ILN277WYKing Steven · Farmington, NMN277XSalopek Rett · Las Cruces, NMN27808St George Flight Academy LLC · St George, UTN2780GHolden Christa · Rougemont, NCN2780XMontgomery Jeffrey L · Anthem, AZN2781DFejes Guide Service Ltd · Anchorage, AKN2781JRussell Scott M · Sanger, TXN2781QGibboney Phillip M · Roseville, CAN2781RBurley Robert L · Alliance, OHN2781WMaddox Robert P · Jarrell, TXN2781XN2781x LLC · Kingston, GAN2782FMansoori Ali S · Aurora, CON2782QBauer Aviation LLC · Reese, MIN2783FVspp Consulting LLC · Stevensville, MDN2783GLarue Terrence W · Ellensburg, WAN2783TCloud 9 Aviators LLC · Anchorage, AKN2783WCrain James D · Hood River, ORN2784GFlaps Up LLC · Kaysville, UTN2784PStogner Michael E · Cuber0, NMN2784TVerastegui Emilio F III · Albuquerque, NMN2784WBoeckman Thomas J · Carroll, IAN2784XGillett Welles III · Horseheads, NYN2785FAugustin Lyn H · Saint Thomas, NDN2785JDurtschi Steven R · Centerville, UTN2785KPontiac Flying LLC · Pontiac, ILN2785MWood Gregory M · North Pole, AKN2785QA&R Aero LLC · Sacramento, CAN2785RTorqerson Leif H · Cut Bank, MTN2785TPatin Carey · New Roads, LAN2785WNienaber David K · Colorado Springs, CON2786FChristoph Nicolas T · Okanogan, WA
Back to AD 2007-04-19 R1