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.
N9115VBovo Paolo · San Benito, TXN9115ZK & C Publications LLC · Spring Valley, OHN9116DPeterson Lauren R · Anchorage, AKN9116JPolcyn Matthew D · Millersburg, OHN9116LShowers Of Blessings LLC · Fredericktown, MON9116TSkinner Jay D · The Woodlands, TXN9117Runnels James A · Dublin, TXN9117LWillkris Aviation Services LLC · Smithfield, VAN9117QBenson Joshua J · Winchester, CAN9117VEdgerton Bruce M · Ottsville, PAN91187Usda Aphis Ws Atoc · Cedar City, UTN9118DYaggie Equipment LLC · Breckenridge, MNN9118HPhillips Raymond B · Inver Grove, MNN9118LDavis Brett M · Madison, MEN9118SSt Pete Aviation Services LLC · Saint Petersburg, FLN9118ZFlying Mermaid LLC · Aiea, HIN9119DArne Blair V · Carpenter, SDN9119JAlex Aircraft LLC · New Albion, NYN9119LPiercy Ronald S · Moses Lake, WAN9119RMiller Robert III DBA · Kittrell, NCN9119TDahab Richard E · Brightwaters, NYN9119VCarlson Tracy W · Henderson, NVN911BUDurante Leonard J · Navasota, TXN911CTMcallen Aviation LLC · Mansfield, LAN911DBRegistered aircraftN911DKJuneau Christopher · Porter, TXN911ELWellevaluations LLC · Wichita, KSN911GGGearhart Joe L · Three Rivers, MIN911GKAluminum Mistress LLC · Cape Coral, FLN911HPBowling Timothy N · Willis, TXN911LBPoehlmann Jeffery L · Austin, TXN911LCNeel Aviation LLC · Lakeland, FLN911NJStewart Michael W · Snellville, GAN911PBaldwin Andrew W · Lander, WYN911PZBrannan Raymond E · Decatur, TXN911RBCanup Billy Hank · Friendswood, TXN911RKBurnley Christopher · Henderson, NVN911RVWilcox John S · Centennial, CON911TAGarwood Brandon · Poland, OHN911THDagnon Scott R · Driggs, IDN911TPCitrus International Aviation LLC · San Bernardino, CAN911UAMiloud Chadd K · Fort Worth, TXN911VCDetgen Ernest J · Carmen, OKN911WGGrischo William · Phoenix, AZN911WWAhler Stephen R · Waitsburg, WAN911YDoggett Jack E Jr · Kingwood, TXN911YLMahon Troy B · Winslow, ILN91202Sonday Terrance P · Red Lodge, MTN91203Helicopter Roundup Service LLC · Nephi, UTN91204Registered aircraft
Back to AD 90-04-06 R1