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.
N7284JGiermek Peter T · Olean, NYN7284LGriffin Alvin G · Mechanicsville, MDN7285FKulp Clayton H · Wichita, KSN7285LMurrell David Tyler · Pensacola, FLN7286LCover George A · Thayer, MON7286QLacombe Bryan K · Rockwall, TXN7286WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLN7286YReagan Scott Lllp · Mount Pleasant, SCN7287GTen Mile Ranch Inc · Vale, ORN7287JJames Leroy R · Renfrew, PAN7287KClapp Carl W · Edmonds, WAN7287PTwo Dot Aircraft LLC · Kalispell, MTN7287WLebouef Kelly J · Rayne, LAN72883Donovan Robert J · Bothell, WAN72884Hawkeye Aviation LLC · Miami, FLN7288FJ&S Aeronautics LLC · Mcgregor, TXN7288KAgha Thanoon J · Anchorage, AKN7288QAerosmith Aviation LLC · Marietta, GAFirst renewal noticeN7288WIndependence Youth Flying Club Inc · Independence, ORN7288YN7288y LLC · Manassas, VAN7289JValdez Jose C · Troy, MIN7289KIberlin Christian J · Gillette, WYN7289LMott Calvin L · Rolla, MON7289WHarris Clark R · Tribune, KSN728AMeridian Aircraft LLC · Wilmington, DEN728CMSchweitzer Gregory M · Tabernacle, NJN728DBStyer David B · Pendleton, ORN728DFExplore Helicopters LLC · Lexington, ALN728DMForkel Stephen P · Bend, ORN728EBeaver Companies LLC · Shelby, NCN728FLFalcon Aviation Academy Corp · Chino, CANon-citizen corporation, flight hours not reportedN728GLMartin James D · Graford, TXN728KGCapsed LLC · Mojave, CAN728KKWeddle Stephen J · Phillips, WIN728NDUniversity Of North Dakota · Grand Forks, NDN728PHornsby Mark · Jackson, LAN728TBAtd Pilot Training LLC · Kansas City, MON728WVeldman Richard D · Laporte, INN728WCUnmanned Systems Inc · Henderson, NVN728WFReigh Galen R · Williamsburg, PAN728ZIrizarry Eduardo F · Columbia, SCN7290JPiper Nicolas A M · Atherton, CAN7290KAnderson Brent J · Whitewater, MTN7291DLehman John Thomas · Corbett, ORN7291FTusing Richard C · Newell, SDN7291GKuntz Jeffrey A · Covington, OHN7291JCenterline Equipment Corp · Waukegan, ILN7291PHenris Air LLC · Onsted, MIN7291WKiser Eugene A · Sheboygan, WIN7292FAalderks Roger H · Blomkest, MN
Back to AD 90-04-06 R1