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.
N59CWN59cw LLC · Sheridan, WYN59CZGlynn Jeffrey L · Pagosa Springs, CON59DGGregory Charles B · Valparaiso, INN59DLChannel Islands Aviation Inc · Camarillo, CAN59DRRanzway Corp · Seattle, WAN59DTN59dt Inc · Malabar, FLN59EAHorizon Aviation LLC · Brooks, GAN59FBCox Steven D · Evergreen, CON59FSRegistration Pending · Yazoo City, MSRegistration pendingN59GTMarianas Mission Aviation Inc · Tamuning, GUN59HAircraft Sales LLC · Caledonia, MIN59HYRitter Mark C · Austin, TXN59JAHare Michael R · Nye, MTN59JHFlying Circus Pictures · Los Angeles, CAN59KBBond Kent F · Woods Cross, UTN59KTLancaster Mark S · Ottumwa, IAN59LAAlphin Lewis Jackson · Mount Olive, NCN59LGWillig Louis · Penn Valley, PAN59LHSpillman Robert L DBA · Port Orange, FLN59LJL & J Aviation Inc · Atwater, CAN59LPHalkett Blair Ross · Knoxville, TNN59LTHall Morgan R · Los Osos, CAN59MSSojka Michael J · Bainbridge, INN59PGStone Aviation Holdings LLC · Myrtle Beach, SCN59PHSeider Jason · Dallas, TXN59PPJohnson Monte W · La Porte, INN59RBRegistered aircraftN59RVNghiem Daniel · Westminster, CAN59SMChandler Ronald J S · Tucson, AZN59SRRaeder James · Caldwell, IDN59TPeters Willie W · Brownfield, TXN59TDDavison Terry W · Melba, IDN59TPRegistered aircraftN59VLKelley Aircraft LLC · Weyers Cave, VAN59WBWhiskey Bravo LLC · Scottsdale, AZN59WDHorner Michael W · Manakin Sabot, VAN59WLHerrmann Mark D · Dillingham, AKN59WMHudson River Wings LLC · Montclair, NJN59WYHat Trick Aviation LLC · Coeur D Alene, IDN59YLPanariello Gary F · Sausalito, CAN59YYBay Richard P · West Jordan, UTN5AASimanski Charles J · Onley, VAN5ADCraig Philip A Jr · West Richland, WAN5AKHackler Tara Cole · Bend, ORN5AUCrosswind Aviation Of Oklahoma LLC · Stillwater, OKN5BHixon Carl J · Clayton, NCN5BJLinrud Michael A · Velva, NDN5BMDja Enterprises LLC · Los Angeles, CAN5BYWolff Emanuel C Md · Tucson, AZN5CMBramall Buster I · Waxahachie, TX
Back to AD 90-04-06 R1