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.
N9203TMartinson Douglas E · Nome, AKN9203VInnovative Poultry Products LLC · Olar, SCN9204JCherokee N9204j Inc · Spanish Fork, UTN9204MBrown Gary M · Wales, MIN9204SHoward Alexander James · Coulterville, ILN9204VDahle Avenue Aviation LLC · Faribault, MNN9205DHayden Scott D · Anchorage, AKN9205JAviation Partners LLC · Greer, SCN9205LJarog Terence A · Denton, TXN9205MSchiro Joseph A · Birdseye, INN9205VBlaylock James · Las Vegas, NVN9205XOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9205YNorman Edward M · Palmer, AKN9206DCarpenter Richard F · Big Lake, AKN9206JBolles Aviation LLC · Johns Creek, GAN9206LHohner Jack B · Spokane Valley, WAN9206MCrews William J · Jacksonville, FLN9206NSkylink Xpress Inc · San Bernardino, CAN9206SJohnson W Norman · Stayton, ORN9206VRegistered aircraftN9206YFejes Samuel T Jr · Anchorage, AKN9207LLindquist Steve · Granite Falls, MNN9207SMr Woodchuck LLC · Naples, FLN9208LBrookway Investments LLC · Brookhaven, MSN9208MWright Matthew K · Hollister, CAN9208SFrush Charles A · Burlington, NJN9209MFloyd Thomas H · Reno, NVN9209QMckeeman Trevor T · Manhattan, KSN920AAGoins Clay Jefferson · West Park, FLN920ACNaples Air Center Inc · Naples, FLN920AJAmerican Patrols Inc · Midland, TXN920ASIndependent Dusting Service Inc · El Campo, TXN920BEGalaxy Aviation LLC · Nantucket, MAN920BTThorpe Brian J · Saint Augustine, FLN920CJJones Alva L · Craig, CON920CPCivil Air Patrol Inc · Maxwell Afb, ALN920ERSunrise Aviation · Ormond Beach, FLN920GBales Don · Oakhurst, CAN920GTBeauchesne Harold J · Enterprise, ALN920HGGreco Robert J · Overgaard, AZN920HWWikstad Herulf L · Nevada City, CAN920JCTrabold Jeffrey G · Kingsport, TNN920JLBaxley Aviation LLC · Baxley, GAN920KBarker Andrew Robert · Portland, ORN920LHHatley Byron J · Sparks, NVN920PHYetiskin Kenan · Huntsville, ALN92103Pgd Flyers Inc · Cape Coral, FLN9210BOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9210HFlex Air Holdings Inc · Wilmington, DEN9210LMid Atlantic Air Museum · Reading, PA
Back to AD 90-04-06 R1