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.
N4705QWings Over Texas Holdings LLC · Denton, TXN4705WPelch Jeffrey W · Dallas, TXN47063Geco Inc · Wilmington, DEN4706DKelly William W · Springfield, ORN4706LKings Heir Inc · Kent, WAN4706ZAirsmith Aviation LLC · Oshkosh, WIN47077Knutson Flying Service Inc · Tioga, NDN4707ASherman Aviation Inc · Redmond, ORN4707CSmith James A · Lyle, WAN4707JBeck Joseph P II · Pollock, LAN4707LJet & Rotor Aviation LLC · Sacramento, CAN4707ZBradsher Larry Flint · Rougemont, NCN4708AFranz Stanley · Yakima, WAN4708LAlexander Nicholas R · Oak Hill, OHN47093Skipper Consulting LLC · Athens, ALN4709LJohannsen Michael R · Allen, TXN4709RG & M Aircraft Inc · Wheat Ridge, CON470AArcher Aircraft LLC · Wilmington, DEN470AKAkima Logistics Services LLC · Usaf Academy, CON470AMSoutheast Lsa LLC · Jacksonville, FLN470CBoese Jon D · Holloway, MNN470DWWhitesell Paul Trustee · Plano, TXN470FLBaker Brian K · Dayton, OHN470FSCustom Air International LLC · Homestead, FLN470HPBloch Christopher P · Grand Rapids, MIN470JKHill Kenneth R · Port Charlotte, FLN470KCColeman Keith T · Mukilteo, WAN470KMAv Chase LLC · Kirtland, OHN470MAKek Companies Inc · Portland, ORN470RPDaytona Aircraft Services Inc · Daytona Beach, FLN470SBMidwest Choppers LLC · Colman, SDN470UNew Horizon Aviation Inc · Warwick, RIN47108Ace Aircraft Leasing Inc · Nazareth, PAN4710LStuhmer Samuel K · Central City, NEN4711BPinnacle Aviation Services Inc · Encinitas, CAN4711JDoucet Joshua A · Cabot, ARN4711LWings Over Texas Holdings LLC · Denton, TXN4711YAerospace Trust Management LLC Trustee · Wilmington, DEN4711ZHanna David A · Keene, TXN47120Shipe Jacqueline M · Louisville, TNN4712AProudfoot Ranches Inc · Ione, ORN4712CPershing Todd Clark · Jacksonville, ORN4712YGoldfarb Alice F · Conway, MAN47133Sunrise Aviation Inc · Ormond Beach, FLN47137Tucker John F · San Luis Obispo, CAN4713BSmith Peter J · Excelsior, MNN4713CTron Aviation LLC · Orlando, FLN4713LHutson Richard M · Trenton, SCN4713ZFailing Amanda R · Wasilla, AKN4714FHastings Stephen J · Palmer, AK
Back to AD 90-04-06 R1