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.
N7579VSteenson James H Jr · Hudson, NHN7579WAll For Yu Consulting Corp · Macon, GAN757AAHeavy Metal Air LLC · Farmingdale, NYN757ABCallum James M · Newport, NHN757ACLewis Aviation Inc · Wilmington, DEN757ADLong Island Aviators LLC · Seaford, NYN757AHRed Sky Aviation LLC · Livermore, CAN757AJSunrise Aviation Inc · Ormond Beach, FLN757AKSloan Kyle C · Anchorage, AKN757APMcnamara William T · Memphis, TNN757AYAdams Steve G · Watsonville, CAN757AZKilo Aviation LLC · East Peoria, ILN757BBarber Shoppe Inc DBA · Cameron Park, CAN757BBKelley Aircraft LLC · Weyers Cave, VAN757BFOld Goat LLC · Wilmington, DEN757BKPfister Mark A · Acworth, GAN757BS4 One Air LLC · Holland, MIN757BVPlayer Dennis M · Union Bridge, MDN757BWK2 Sales LLC · Idaho Falls, IDN757CSwasey Brian Paul · Woodland, CAN757CG4g Family LLC · Dover, DEN757CQPorter Casey · Bluffton, SCN757CSBowers Scott · Mc Donald, PAN757CTAero Fliers LLC · Kalispell, MTN757DAHuston Wes · Sanger, TXN757DEMavity Michael D · Phoenix, AZN757DFWisener Lupita A · Mineola, TXN757DKKickbush David L · Guttenberg, IAN757DLRegistered aircraftN757DQIowa Great Lakes Flyers Inc · Cheyenne, WYN757DSCummings Scott A · Monitor, WAN757DTStar City Aviation Inc · Roanoke, VAN757EHWings Over Texas Holdings LLC · Denton, TXN757ENMontana Flying Service LLC · Missoula, MTN757EVRoth Michael L · Lanse, MIN757EWMagin Sonny K · Harvest, ALN757EXRound Engine Aero · Nashville, MIN757FCBoland Matthew S · Anchorage, AKN757FDR&R Aero Services LLC · Eden Prairie, MNN757FEMock Joseph R · Huntsville, TXN757FFAir-Planes LLC · Soddy Daisy, TNN757FHSilverman Mitchell G · Cumberland, RIN757FJGeorge Alexander Vasil Jr · Haverhill, MAN757FQMundis William L · York, PAN757GEEllis Wendel K · Chugiak, AKN757GNExecutive Wings LLC · Bolivar, TNN757GQAngel Aviation Inc · Peoria, AZN757GXWinging It Aviation Two LLC · Gulf Shores, ALN757HAKim Sungtae · Fort Worth, TXN757HCBaker David L · Leavenworth, KS
Back to AD 90-04-06 R1