AD 91-08-07
Registered aircraft · 6,062
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:91-08-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-08-07')
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:91-08-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:91-08-07') 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.
N113BPSouthern Aircraft Consultancy Inc Trustee · Casper, WYN113ECCarrasco Enrique · Jupiter, FLN113HMAkins Tal M · Register, GAN113MVRettig Air LLC · Riverside, CAN113TLKramer David P · Lebanon, TNN113TRBell Thomas E · Henniker, NHN1140XReaper LLC · Britton, MIN11414Van Bortel Aircraft Inc · Arlington, TXN114ADBailey Walter A III · Cincinnati, OHN114BLLoose David C · Blanco, TXN114GTEnders Richard A · San Bernardino, CAN114JTVanbeek Donald Eugene · Tualatin, ORN114KR H Welsh LLC · Crescent City, FLN114MDUrsic Albert J · Minden, NVN114MTSattig Henry B II · Cortez, CON114PBBernabucci Christian J · Mapleton, NDN114PRC W 3 LLC · San Juan, PRN114RCAsbury William A · Bridger, MTN114RRMdb Air LLC · Poway, CAN114RWLaw C Scott · Oklahoma City, OKN114SACustom Air International LLC · Homestead, FLN114TBWelch D Michael · Foster City, CAN114TLLa Soplaera Realty LLC · Niwot, CON1151ZRenfro Michael W · Bethel, AKN1154XKelley Jay D · Lake Havasu City, AZN1155TCaljet Aviation LLC · Magnolia, TXN1157SDig2fly LLC · Sandpoint, IDN115DWMav LLC · Erie, CON115GTWahl John H · Rockwell City, IAN115JDC R Aviation Inc · Miami, FLN115KTMulva Jonathan · De Pere, WIN115MDSpecial Orthogonal Group LLC · Dover, DEN115SZThree Greens LLC · San Jose, CAN1165XLechtenberg Lance · El Dorado, KSN116GWMajestic Airlines Inc DBA · Lynden, WAN116MFWeber Donald E · Saint David, AZN116RCMiesch Gary D · Gowen, MIN116SMArchie Aero LLC · Beaverton, ORN1176ZAirborne Support Inc · Bourg, LAN117BMManeck Aviation LLC · Columbus, GAN117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKN117KRFox Planes LLC · Sterling Heights, MIN117SEHalsell Jason · Wolfforth, TXN117TDGiffin Craig D · Windermere, FLN1180XK & K Aero Inc · Wilmington, DEN118ESCmv Aviation LLC · Johnson City, NYN118JGRopewalk Investments LLC · Wilmington, DEN118MCAlpha Whiskey 3 LLC · Brandon, MSN1191AMoore John C DBA · San Miguel, CAN1197LBoothe Vincent A · Fairhope, AL
Back to AD 91-08-07