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.
N4470ZRegistration Pending · Weatherford, TXRegistration pendingN44710Bonin David P · Belmond, IAN44714Burchfield Bill · Tanner, ALN44715Skogen Karl L · White Bear Lake, MNN4471ZEgolf Charles F · Spokane, WAN4472FA&J Aircraft Leasing Inc · Burlington, CON4472HSalamon Uri · Boerne, TXN4472RFlyrite Aviation LLC · Fort Myers, FLN4473FPate Elaine · Thousand Oaks, CAN4473HUhlenhopp Eldon K · Ames, IAN4473JAj Aviation LLC · Gwinner, NDN4473PSemeniuk Steven T · Houston, TXN4473RMiller Keith A · Reedy, WVN4473XSlipstream Aviation LLC · Calera, ALN4473YJackson Robert S · Gallatin, TNN4473ZEriksen Rodney B Trustee · Juneau, AKN44741American Airpower Heritage Fly Musm · Dallas, TXN44749Hoprich Jeffrey S · Roanoke, VAN4474FN44107 LLC · Marlton, NJN4474XToledo City School District · Swanton, OHN4474ZWatts Craig W · Incline Village, NVN44753Registration Pending · Torrance, CARegistration pendingN44754Greenville Pickens Roundtrac LLC · Easley, SCN4475JHilburn Brian · Philadephia, PAN4475PRamaswamy Gautam · Clearwater, FLN4475TWings Over Texas Holdings LLC · Denton, TXN44761Henderson Gregory S · Saltsburg, PAN44763Flying Peanuts LLC · Wilmington, DEN44764Hess Alex · American Fork, UTN44769Merriam Lowell · Chowchilla, CAN4476EN4476e LLC · Saint Charles, MON4476HHutson Ac N · Griffin, GAN4476ZS And C Flying LLC · Pierre, SDN44771Benedict Kevin M · Lakeland, FLN44772Hanson Donald H · Bellevue, WAN44773Nair Vihas G · Philadelphia, PAN44775Heuerman Jordan D · Casey, ILN4477ABrown Danny J · Skidmore, MON4477PAirknocker Inc · Wilmington, DEN44786Flight Academy LLC · Van Nuys, CAN44789Dzialo Matthew J · Pawtucket, RIN4478AOrth Henry J · Wasilla, AKN4478JFly 500 LLC · Fort Pierce, FLN4478TSchroder David A · Venice, FLN4478XWhite Raymond W · Montrose, MIN44790Spence William M · Naples, FLN44792Ocean Air Inc · Eugene, ORN4479RUp And Up Aviation LLC · Magnolia, TXN4479TSouthern Colorado Flight Professionals LLC · Pueblo, CON4479ZHardan Weston W · Palmer, AK
Back to AD 90-04-06 R1