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.
N4085PTango Bravo Aviation LLC · Taylorsville, MSN4085WIrvin Gary Z · Parrish, FLFirst renewal noticeN40862Ratliff William Thomas III · Knoxville, TNN4086KRobinson Mark V · Vacaville, CAN4086MBudak Mark · Melba, IDN40872Ole South Aviators LLC · Athens, GAN40874Jones Sherman Farrell · Buena Park, CAN40875Meidinger Timothy J · Klamath Falls, ORN40876Gray John W · Rohnert Park, CAN4087PPankratz Laura M · Stroudsburg, PAN4087ZNcsb LLC · Anchorage, AKN4088Katz Matthew · Los Angeles, CAN40881Hsu Feng · Albuquerque, NMN40882Flight Factory LLC · Danville, CAN4088FCole Warren G · Watkinsville, GAN4088MRam Aviation LLC · Palmer, AKN4088PBas Part Sales LLC · Greeley, CON4089Indrebo Rick J · Livermore, CAN4089FKorb Orry P · Santa Cruz, CAN4089MViens Ernest W · Eagle River, AKN408BWKough David M · Nashville, TNN408CACoast Flight Training And Management Inc · Dallas, TXN408EZKoester David P · Newport, ORN408FHStevens William C · Ashland, MTN408FLSmith Benson H · Herington, KSN408JMRobinson Wayne D · Highlands Ranch, CON408JNTvpx Ars Inc Trustee · North Salt Lake, UTN408LTDecathlon LLC · Lincoln, NEN408TWWayne Terry · Belews Creek, NCN408ZAlpha Tango Aircraft LLC · Wilmington, DEN40903Boyer Aviation LLC · Kiel, WIN40904Allred Klein Enterprise LLC · San Diego, CAN40905Martin James Christopher · South Jordan, UTN4090EAerodrome LLC · Louisville, KYN4091PPaulay Sandor F · Kenmore, WAN4091ZA G Sholton Co · Wasilla, AKN40925High Flight Academy LLC · Allison Park, PAN4092MSmith Dennis L · Carthage, NCFirst renewal noticeN40935International Air Services Inc Trustee · Carson City, NVN40936Aerial Sign North Inc · Lakewood, NJN40939Grog Holdings LLC · Dallas, TXN4093PLumley John J · Delray Beach, FLN4093XBartholomeo Daryl A · Cleveland, OKN40940Williams Richard S · Longview, TXN40945Mount Eagle Inc · Alexander, ARN4094MVaughn Charles M · Titusville, FLN4094PShelley Isaac R · Scottsville, VAN40951Grant Constance R Trustee · Eaton, INN40953Cws Capital Holdings LLC · Saint Petersburg, FLN40957Roberts Linda L · Bell Buckle, TN
Back to AD 90-04-06 R1