AD 75-08-03
Registered aircraft · 10,858
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:75-08-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-08-03')
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:75-08-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-08-03') 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.
N1122ACox Abraham · Key West, FLN1123WThiel Jonathan Ronald · Billings, MTN1125TSpruce Tiger Aviation LLC · Dallas, TXN1125XApm Leasing LLC · Casper, WYN1126XBolobonoff Alexander G · Kingman, AZN112JMGuzman John · China Spring, TXN112JRValleau Matthew J · Wallingford, CTN1138FSky West Aviation Inc Trustee · Albuquerque, NMN1138XPierce Nathaniel Antonio · Magnolia, DEN113EJIxi LLC · West Bloomfield, MIN113KRIal Corp · Lewes, DEN113WYRyals Barry · Rhine, GAN1144XFly Texas Sky LLC · Arlington, TXFirst renewal noticeN1147XPax Flyers LLC · Hollywood, MDN114CFAw Chartering LLC · Franklin, TNN1150XVenture North Aviation LLC · Cloquet, MNN1157XAscend Aviation LLC · Bountiful, UTN1158HOs Flight LLC · Double Springs, ALN1159XBarrett Tyler J · Cullman, ALN115DCLong Jerry D · Solvang, CAN115JAFarmer Stephen E · Tullahoma, TNN1160XWagner Robert J · Dubuque, IAN1161HEngert Armin L · Kahului, HIN1163XPerry Curtis · Klamath Falls, ORN1164XRegistered aircraftN1167XHoover Adam A · Sugarloaf, PAN1168XJz Air LLC · Brooklyn, NYN1178XN1178x LLC · Dover, DEN1179XDesch Edward J III · Aldie, VAN117DWFerrand Kathy M · Cornelia, GAN117MTHinkle Robert J · Caldwell, IDN117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CAN1181HAdams 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, CAN1196XMedic Choppers LLC · Springdale, ARN1198XDiscover Aviation Center LLC · Elyria, OHN119A2is Partners LLC · Vero Beach, FLN119HPValiair Limited Company Trustee · Casper, WYN119JDUSA Wiltshire LLC · Pembroke Pines, FLN11FLBell Christopher K · Ashley, OHN11GERusso James F · Liberty, SCN11GKBaden Michael · Waxhaw, NCN11GNHaley James M Trustee · Edmond, OKN11HAVintage Aero Inc · Brandon, FLN11JUPottorff Gregory K · Wayne City, IL
Back to AD 75-08-03