AD 95-26-16 R1
Registered aircraft · 1,406
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:95-26-16-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:95-26-16-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:95-26-16-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:95-26-16-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.
N50RSStone Raymond J · Felton, DEN511MSBarrow Justin · Santa Fe, TXN51AMKerns Joshua S · Leander, TXN5201CCordero Jose Robert · El Paso, TXN5201DGriffin Thomas S · Spartanburg, SCN5201LMelchiorre Joseph G Jr · Milton, DEN5201NMarr Christopher M · Morrisville, NCN5201UMccrary Enterprises LLC · Port Jefferson, OHN5201VMg Aircraft Inc · Fort Lauderdale, FLN5201XSims Raymond H · Navarre, FLN5201YShared Momentum LLC · Wilmington, DEN5211ZFlightwerx Inc · Deland, FLN5215ADrake James R Jr · Lawrenceville, NJN5216EHerrera Teodoro Humberto · El Paso, TXN521SFCarey Kevin · Brighton, MAN523JSOlson Jon II · Drake, NDN5240UEllison Bradley B · Condon, MTN52481Wings N Gold LLC · Lewes, DEN5249UPixley Andrew Don-George II · Rochester Hills, MIN524RAMiller Seth · Lafayette, INN52503Mooney 52503 Flyers · San Diego, CAN5254NOrbelo Robert W · Farmington, NMN5254TMillion Air LLC · Las Vegas, NVN5255SAkc III Aviation LLC · Port Saint Joe, FLN5257QNott Michael A · Lake Havasu City, AZN5257TLangel Michael L · Huntington Beach, CAN5258GMooney N5258g LLC · Kalispell, MTN5259CMcsorley John A · North Augusta, SCN52611Ronnau James F · Overland Park, KSN5262AMcgowen Douglas R · Virginia Beach, VAN5262FRegistered aircraftN52641Birk Aviezer · Saint Augustine, FLN52646Lobianco John · Woodmere, NYN526SAGumps LLC · Jersey City, NJN5270WReigle Tom J · Madison, NEN5272KGarmin International Inc · Salem, ORN5275TLisenby Joseph W Jr · La Conner, WAN527RJGonzales Denise E · Fort Worth, TXN5280JKnopp Kenneth J · Nashua, NHN52840N52840 LLC · New York, NYFirst renewal noticeN52848Danzig Solomon · Alpharetta, GAN5288GC&B Air Services LLC · Wilmington, DEN529PAPaccone John E · La Canada, CAN531DDPratt Bruce C · Sausalito, CAN531DELand Farming Inc · Kulm, NDN53RHRoyal Blue Medical Inc · Hanceville, ALN547DWWasser Thomas · Lyons, NYN54ERKhandpur Rajiv K · Hicksville, NYN555EDPoteet-Schwartz Kim L · Albuquerque, NMN558MSynergyair Ltd · Lewis Center, OH
Back to AD 95-26-16 R1