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.
N5480KAmerican Patrols Inc · Midland, TXN5480LCooper Derek M · Austin, TXN5480WAikin Denver · Owasso, OKN5480ZLauritzen Ethan J · Wild Rose, WIN54812E & E Aviation LLC · Kingshill, VIN5481MAlpha Wings Inc · Willoughby, OHN5481WBawden Frederick M · Brookfield, WIN5481ZDicenzo Eugene N · Cumberland, RIFirst renewal noticeN54829Aviate LLC DBA · Hazelton, IDN5482GBorne Shaun M · South Rockwood, MIN5482LEgli Dru D · Howe, INN54832Maskityj LLC · Hagerstown, MDN54838Draco Flight School DBA · Chino, CAN5483HKriner Steven J · Billings, MTN5483KIzzo Michael D · Phoenix, AZN5483LLawton George F · Auburn, CAN54844Dynasty Adventure Inc · Mentone, CAN54849Colorado Northwestern Community College · Rangely, CON5484DAerobiz LLC · Lewes, DEN5484LAugustine Robert J · The Villages, FLN5484PRussi Kenton S · Caldwell, IDN54851Metz William H · Laurel, MTN54855Christiansen Aviation LLC · Wilmington, DEN5485HGiron Lawrence · Anchorage, AKN5485KBarr Air Patrol LLC · Mesquite, TXN5485LBeaudry Charles F · Graham, NCN5485MN446rh LLC · Helena, MTN5486DFord Bernard DBA · Sidney, NYN5486HWhisonant Robert J · Winnett, MTN5486LStelly Christopher · Houston, TXN5486PHorton James D · Las Vegas, NVN5487BPotcake Aviation LLC · Missoula, MTN5487FKettlehut Alan W · Ceresco, NEN5487KRingen Marvin O · Beaverton, ORN5487LLaw C Scott · Oklahoma City, OKN5488MPerson Michael · West Chester, PAN5488PScheuermann Hugo T · Cape Coral, FLN5488TWestphal Ronald R · Aurora, ILN5488ZLand Cecil J · Goshen, KYN5489HMcmahan Charles B · Gakona, AKN5489LRib Runner LLC · Sioux Falls, SDN548CLSpielmann Thomas G · Aurora, INN548CWCentral Washington University · Ellensburg, WAN548DGorowsky Craig · Tucson, AZN548ECRaney James R · Tucson, AZN548FDScattertown Holdings LLC · Montross, VAN548MMLittle Atlas Air LLC · Montgomery, ILN548MWMalone John Grover · Jasper, FLN548SCSpartan Education LLC · Tulsa, OKN548SMMorrow James S · Gilbert, SC
Back to AD 90-04-06 R1