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.
N5890VEller Patricia E · Lutz, FLN5891DRiggs J'Ann · Wasilla, AKN5891HFelske Michael J · East Troy, WIN5891LAlldridge Thomas H · Cochranville, PAN5891RTun Bay Inc · Wasilla, AKN5891U2dwh LLC · Katy, TXN5891WMarino Mario Mennona · King Of Prussia, PAN58923Singh Jaspal · Sacramento, CAN5892UFeighl Engineering Group Inc · Hot Springs, ARN5892ZCarbiener Ross · Kewanee, ILN5893HAmos Derek L · Helena, MTN5893LHegwood Jonathan E · Petal, MSN5893UCasper Gary · Spring Creek, NVN5893WFinch Howell M Jr · Victoria, TXN5893ZKugmach LLC · Holdrege, NEN5894LTrueblood Terry L · Effingham, ILN5894QBlech Fritz · Grants Pass, ORN5894ZRussell Webster K · Ridgeland, MSN5895HThompson Timothy G · Kenosha, WIN5895LWatkins Marion D · Mcdonough, GAN5895ZMerrick Richard W · Bernville, PAN5896UGift Academy Inc · Vernon, TXN58975Anderson Kirk M · Prosser, WAN5897LCulver Christopher J · Rockmart, GAN5897QBarsi Jeffrey D · Bonham, TXN5898LLamer Benjamin W · Ada, MIN5898QO'Neal Timothy L · Damascus, ORN5898VMaxair Inc · Coxs Creek, KYN5898WFrazier Justyn K · Mesa, AZN589APa28 Aircraft LLC · Wilmington, DEN589CBBryan Curtis · Enumclaw, WAN589LAPiper 3 LLC · Chestnut Ridge, NYN589RAMcgowin James E · Ball Ground, GAN589RPEdmundson George · Hood River, ORN589SCSpartan Education LLC · Tulsa, OKN589SPHillsboro Aero Academy LLC · Hillsboro, ORN589TFam Vans Inc · Fountain Valley, CAN589TRRussell Tony B Jr · Severance, CON58AEKraujales Adam M · East Moriches, NYN58ATTurner Michael A · Cartersville, GAN58BWarnick Ronald S · Cascade, MTN58BABank Of Utah Trustee · Salt Lake City, UTN58BFH Jack Flash Inc · Fort Worth, TXN58BGStassi Jean-Paul A Jr · Henagar, ALN58BHPierson Ted · Gooding, IDN58CTS 1t LLC · Parkland, FLN58DSBalliet Edgar J III · Northampton, PAN58FSClark Mitchell P R · Drewsey, ORN58GSzarek Evelyn Personal Representative · Fairbanks, AKN58GMWanless Dax D · Granite Falls, MN
Back to AD 90-04-06 R1