AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N3652JJet Boy LLC · Carlsbad, CAN3652LJbm Aviation LLC · Mc Leansboro, ILN3652SBennett Quinn S · Sterling, AKN3653JGrachev Timofey · Hammond, WIN3653LRistau Kent T · Eagle Grove, IAN3653VPlane Fun Inc Tr Trustee · Snellville, GAN3654LHeritage In Flight Museum Inc · Lincoln, ILN3654VKellermann Denis John · Lompoc, CAN3655KDyson Raymond E · Vero Beach, FLN3655VRobertson James E · Yucca Valley, CAN3656JLofland Aviaiton LLC · Moscow Mills, MON3656SBell Michael L · Spokane, WAN3656VWells Charles L III Administrator · Jacksonville, FLN3657LHollabaugh David S · Fulton, MON3657SIsakson Dennis E · Van Tassell, WYN3657VCollins Leon R · Palestine, TXN36581Blaisdell Leo F · Kalkaska, MIN3658HAshlock Donald Earl · Rockwall, TXN3658JBernbeck Alan R · Benton, KSN3658LGraczyk Michael E · Lake Elmo, MNN3658SOrlovich John A · Boise, IDN3659JHenderson Mark A · Duluth, GAN3659SWeed Thomas W · Limington, MEN3659VBeech O Sphere LLC · Casper, WYN365JBHentges Dave · Canby, MNN365RARanger Airfield Foundation · Ranger, TXN3660LBersig James R · La Palma, CAN3661SMiller Harvey L · Livonia, MIN3662JDeninger William J · Northbrook, ILN3662LPrice John C · Bennington, KSN3663SFranks Richard W · Moville, IAN3663VCordova Jose F · Anaheim, CAN36645Kaufmann Chad · Lewiston, IDN3664LNixon Robert W · Mc Alpin, FLN3664SWasson Tom L · Lakeport, CAN3664VPerfect Aircraft LLC · Ocala, FLN3665Bohrer-Padavos Serafino · Lutz, FLN3666JKoseogle Ali Ozan · Longmeadow, MAN3666SBerry Mike J · Palo Cedro, CAN3667JAbbruzze Michael J · Boynton Beach, FLN3667SOliva Louis F III · Anchorage, AKN3667VDonohue Cody T · San Antonio, TXN3668JBrown Richard C · Adrian, MIN3668LMaui Skyhawks Inc · Kula, HIN3668SWm Aviation LLC · Moncks Corner, SCN3668TSchachle Jeremiah K · Houston, AKN3669LNovacek Jeffrey J · Minneapolis, MNN3669SKeller Kenneth Ray Jr · Jonesboro, ARN3669TGrey Brian S · Walker, MNN3669VMeyjes Gus · Cadillac, MI
Back to AD 94-05-05 R1