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.
N83ERMike Smith Aviation International Inc · Rancho Murieta, CAN83EWTremarco Philip J · Anchorage, AKN83FDBury Christopher E · Hawthorne, CAN83FPPhillips Tom Scott · Beach City, TXN83GMRobbins William · Mansfield, LAN83JDRegistered aircraftN83JEKeenan Drew P · Chico, CAN83JMRutan Aircraft Flying Museum · Waller, TXN83JRPriest Justin · Arlington, WAN83KTTaylor Paul A · Overgaard, AZN83LHHelms Timethy M · Hamilton, MTN83LMJohannsen Gregory A · Salina, KSN83MAJones Stephen W · Tampa, FLN83MTApplebaum Steven · Morton Grove, ILN83MZZeitlin Marc J · Tehachapi, CAN83NMMayo Michael J · Palo Alto, CAN83PCColin Patrick L · KororN83PHValiair Limited Co Trustee · Casper, WYN83PJSupan David M · Elk Grove, CAN83PSBurt Donald H · Mason, MIN83PYDecino Robert D · Fritz Creek, AKN83RAardema Robert J · Kalamazoo, MIN83RQBlais Michel · Jackson, TNN83RTWilliamson Tracy C · Texarkana, TXFirst renewal noticeN83TMCimino Joseph Michael · Decatur, ALN83TXPike Alan D · South Portland, MEN83VSherrer Eric W · Santa Paula, CAN83VCDoke Ken L · Winton, CAN83WJSikes Randell D · Dandridge, TNN83WYN265bn LLC · Waterloo, NEN83ZCrittenden William F · Spokane Valley, WAN84001Darcy Aviation LLC · Danbury, CTN84007Smith Michael W · Sharon, CTN84009Swenson Catherine A Trustee · Meadow Vista, CAN8400LInstant Print Signs & Designs LLC · Kalispell, MTN8400SParks Perry A · Goodell, IAN84014C-140 Company LLC · Milton, FLN84015Tarakji Mohamad Hani A · Van Nuys, CAN84019Snodgrass William D · Moberly, MOFirst renewal noticeN8401FSchriner Keith D · Lanark, ILN8401LBlack Baron Air LLC · Kalispell, MTN8401RLaplante David W · New Baltimore, MIN8401TWingsleasing LLC · Wichita, KSN84024Maurano Michael R · Long Island, VAN84026Smith William A Jr · Tulsa, OKN8402CConner W Larry · Los Lunas, NMN8402LVan Bortel Inc · Victor, NYN8402RLivengood Leasing Co LLC · Mesa, AZN8402WAnderson Thomas · La Quinta, CAN84032Eide Donald B Trustee · Webster, MN
Back to AD 90-04-06 R1