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.
N5462LGilbert Jason J · Oakland, MEN5462QLeading Edge Flight Academy LLC · Bend, ORN54633Warner Walter M · Willow, AKN54634Savannah Airplane Venture LLC · Myrtle Beach, SCN54635Memphis Navy Flying Club · Millington, TNN5463KRick Aviation Inc · Newport News, VAN5463LMcpherson Allen G · Batesville, INN5463WAngels Envy Aviation LLC · Denison, TXN5464Larson Margaret June · Shelbyville, TNN54646Jordao Isabella C · Oklaunion, TXN5464DJprg Aviation Inc · Orlando, FLN5464KTrend Vector Aviation International Inc · Barrigada, GUN5464LKelly Michael J · American Fork, UTFirst renewal noticeN5464PDanig Aviation LLC · Newark, NJN5465KMonroe Pilots Association LLC · Monroe, NCN5465WCotrell Rick G Trustee · Troy, OHN54661Executive Flyers Inc · Sacramento, CAN54663Colorado Northwestern Community College · Rangely, CON54665Registration Pending · Talking Rock, GARegistration pendingN5466D5466 Delta LLC · Costa Mesa, CAFirst renewal noticeN5466LFinkbiner Gregory A · Kennesaw, GAN5466UJasper Aviation Inc · Jasper, ALN5466ZKlempel Reuel D · Eltopia, WAN54678Aero Association Of Caltech Inc · Pasadena, CAN5467LKirk Kenneth G Trustee · Sebring, FLN5467SBlach Edmund Jerome · Nashville, TNN5467USinor Delbert D · Ozark, MON5467WGovender Sagren K Jr · Houston, TXN5467ZWilliams Mark L · Denham Springs, LAN54680Yanagida Kazuaki · Norco, CAN5468HPrjc Properties LLC · Vonore, TNN5468LStewart Kenneth R · Allen, TXN5468RCw Arborists Ltd · Killingworth, CTN5468WSitton David F · Mebane, NCN5468ZJensen Larry F · Millington, MIN5469HBonny Brad J · Sunnyside, WAN5469KAviation Specialists Inc · Apison, TNN5469LHovanec Robert R · Mineral Ridge, OHN546BNavigation Leasing LLC · Castle Rock, CON546CACoast Flight Training And Management Inc · San Diego, CAN546CWCentral Washington University · Ellensburg, WAN546DKMcghee Billy H · Deland, FLN546MCLeaseair LLC · Wilmington, DEN546PSClimb LLC · Kalispell, MTN546SCWessel Marvin E Jr · Camp Verde, AZN5470KSkye Aircraft LLC · Deland, FLN5470WRegistration Pending · Bulverde, TXRegistration pendingN5470ZGordon Robert F · Collins, MON54715Apt Aero LLC · Port Angeles, WAN5471LJc Investors Group LLC · Coral Springs, FL
Back to AD 90-04-06 R1