AD 2013-02-13
Registered aircraft · 24,007
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:2013-02-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:2013-02-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:2013-02-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:2013-02-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.
N117JCHillsboro Flying Club · Hillsboro, ORN117MBLittmarck Svante · Dedham, MAN117MTHinkle Robert J · Caldwell, IDN117RKAlon Guy · El Paso, TXN117SCJenkins Matthew A · Bend, ORN117SEHalsell Jason · Wolfforth, TXN117TKWindstar Air LLC · Carroll, IAN117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CAN1180XK & K Aero Inc · Wilmington, DEN1181HAdams Dustan David Sr · Houma, LAN1184DZwick Noah Geary · Dunkirk, MDN1184XLairson Samuel E III · Ocean City, NJN1185HJcaviator LLC · Matthews, NCN1185XWilliamson Flying Club Inc · Williamson, NYN1188TAbrams Jeffrey Scott · Phoenix, AZN1188XSteven H Baker Construction Co · Big Bear City, CAN118ATAirline Transport Professionals Corp Of USA · Wilmington, DEN118BJOn Final Aviation LLC · Brookland, ARN118ESCmv Aviation LLC · Johnson City, NYN1190HBergman William George · Muskegon, MIN1191HBurford John W Trustee · Madison, MSN1194HCrnic Paul C · Chesterfield, MON1194XCantrell William Terry · Spring Hill, TNN1196XMedic Choppers LLC · Springdale, ARN1198HAlge Aviation · Middletown, DEN1198XDiscover Aviation Center LLC · Elyria, OHN119A2is Partners LLC · Vero Beach, FLN119AVFour Mac Air LLC · San Diego, CAFirst renewal noticeN119BTDelaware US Investments LLC · Corpus Christi, TXN119GGYepes Hurtado Andres F · Lubbock, TXN119GSDall James R Jr · Hayes, VAN119HPValiair Limited Company Trustee · Casper, WYN119JDUSA Wiltshire LLC · Pembroke Pines, FLN11CASky Dragon LLC · Atlanta, GAN11CWJabez Aviation LLC · Petaluma, CAN11FLBell Christopher K · Ashley, OHN11GERusso James F · Liberty, SCN11GKBaden Michael · Waxhaw, NCN11GNHaley James M Trustee · Edmond, OKN11HAVintage Aero Inc · Brandon, FLN11HKJohnson Wendell F · Harlingen, TXN11HRHf Aero LLC · Lusby, MDN11JUPottorff Gregory K · Wayne City, ILN11KAlbers Edward C · Burlington Flats, NYN11KXN11kx LLC · Santa Clara, CAN11LYBishop Jay K · Columbus, INN11NTSabb Anthony · Wetumpka, ALN11RPN11rp LLC · Brecksville, OHN11RRRichardson Randy R · St Thomas, VIN11UZEastern Stearman Inc Trustee · Leesburg, VA
Back to AD 2013-02-13