AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N7554WWiener Scott J · Santa Barbara, CAN75555American Patrols Inc · Midland, TXN75559Gillanders Robert Ross Personal Representative · Gig Harbor, WAN7555DHardwick James David · Midland, TXN7555GSac Air LLC · Citrus Heights, CAN7555JKeller Terry · Sedona, AZN7555KDunbar Archie P · Whitewater, MTN7555VWallen Bruce R · New Britain, CTN7555YHirvonen Jukka Matti · Oak Ridge, NCN75560Nexga Aircraft Inc · Greensboro, NCN75565Flight 915 LLC · El Paso, TXN75566Wilson Robert J · Annville, PAN7556FWetzel Gehred · Factoryville, PAN7556GWetlesen Gabriel C · Palmer, AKN7556JKern Aviation LLC · Shawnee, KSN7556VWennerstrom Kirk · Norwalk, CTN7556WSamuelson Dirk H · Orland Park, ILN75571Kohls Bruce P · Melbourne, KYN75572Bean Keith Owen · Glenwood, IAN75575Mayo William J Jr · Reed Point, MTN7557DRandolph David L · Adrian, MIN7557GLe Gros Donald P · Jennings, LAN7557VTexas Dentco LLC · El Paso, TXN7557WBaer William T · Chariton, IAN75586Adventist World Aviation · Wilson, NCN75587Ullah Muhammad K · Federalsburg, MDN75588Emry Scott D · Brookings, ORN7558DMaschuck Eric A · Elysburg, PAN7558FSchaller Lee · New Athens, ILN7558GKessler Garry A · Lansing, WVN7558KCudworth Jay P · Sheyenne, NDN7558LBahinting Dan Brian M · Rosamond, CAN7558RDodson Collin B · Weston, WVN7558VSisk James G · Coppell, TXN75590Burgess Wayne R · Brown City, MIN75591Reynolds Darryl G · Wills Point, TXN75596Christian Charles R · La Crescenta, CAN75598Columbia Jet Center Inc · Columbia, MON7559DDelta Pacer LLC · New Iberia, LAN7559FDodge Donald V · Newnan, GAN7559GLopez Johnny · Henderson, NVN7559JHale Edward L · Kingfisher, OKN7559PSmith Joseph S · Renville, MNN7559RPetersen Josh · Wasilla, AKN7559VNorton Lyle K · Coquille, ORN7559WOwens Alvin D · Malden, MON755BFFulghum Matthew R · Woodside, CAN755DGFerwerda Bryan R · Sioux Falls, SDN755DKJorgen Skovbjerg · Angwin, CAN755GCareer Pilot Training LLC · Wilmington, DE
Back to AD 90-04-06 R1