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.
N5017MNo Limits Aviation Inc · Lincoln, MTN5017RR&R Leasing LLC · Fargo, NDN5018PTseng Leon Y · Tucson, AZN5018UFlight Gate LLC · Wilton, CAN5018ZDowning John D · Marion, MIN50193Folsom Gary A · Marianna, FLN5019SGordon Patricia I · Desoto, TXN5019WShipley Kelly R · Astoria, ORN5019ZCsapos Garry A · Ovid, MIN501AHOlah Gregory J · High Point, NCN501BAFalcon Air LLC · Orlando, FLN501BSBlue Skies Enterprises Of Texas · Richmond, TXN501CHill Chad M · Makinen, MNN501DWParmar Bluffs LLC · Parker, SDN501EHDupont Pierre B · Menominee, MIN501ELJourneys Aviation Inc · Boulder, CON501ERVista Air Inc · Pacoima, CAN501GLSharp Aviation LLC · Pauls Valley, OKN501HLAarow Aircraft Leasing LLC · Mcminnville, ORN501JAAlongi John J · Downers Grove, ILN501MAContinental Aerospace Technologies Inc · Mobile, ALN501MERoby Gregory Carl · Owensboro, KYN501MPManzoor Khan · Stockton, CAN501PLDick Timothy R · Fox Lake, ILN501PWFlywerx LLC · Anchor Point, AKN501RDBackcountry Endeavours LLC · Dassel, MNN501REIndependence Aerospace LLC · Kennesaw, GAN501RVSaunders Steven M · Elizabeth City, NCN501SDNordeen Christopher L · Salinas, CAN501TSFlying Tigers Flight School LLC · Houston, TXN501ZNorth Georgia Helicopters Inc · Calhoun, GAN50208Haus Jesse M · Fort Worth, TXN5020HBorreson Anthony · Mariposa, CAN5020PThurston Steven C · Salisbury, NCN5020RMigliaccio Jason · Palm Bay, FLN5020SSchneider Robert R · Fort Benton, MTN5020TBetlach Christopher Thomas · Kenmore, WAN5020WAndersen Richard W · Vail, AZN5021HAlamo Flyers LLC · Elmendorf, TXN5021RWax Sally G · Louisville, KYN5021ZFansler Rick L · Delta, OHN50227Taylor Carter · Los Angeles, CAN5022WHovendick William P · Lander, WYN5023LIsland Hoppers Seaplanes 2 LLC · Orlando, FLN5023RStern Joseph L · Morrow, OHN5023SSummit Arrow Adventures LLC · Peyton, CON5023ZBauer Glenn D · Wishram, WAN50246Taubman Jason · Greenland, NHN50247Haywood Charles E Jr · Valrico, FLN5024PSun Aviation Inc · Santa Clara, CA
Back to AD 90-04-06 R1