AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N3045FFinley Eric · Ione, CAN3045QLong Randy B · Coleman, TXN3046FPlane Brilliant · Odessa, FLN3046QN3046q LLC · Colorado Springs, CON3047QWiechmann Michael D · Friendswood, TXN30488Valiair Lc Trustee · Casper, WYN3048QBad Eagle Aviation LLC · Fulshear, TXN3049EConnor Leslie W · Venice, FLN3049FFriendship Flying Service Inc · Lexington, KYN304CACivil Air Patrol · Maxwell Afb, ALN304CGVan Bortel Aircraft Inc · Arlington, TXN304DB4db Leasing LLC · Englewood, CON3050BNelson William W · Saint Petersburg, FLN3050YSmith Adam M · Holloman Afb, NMN30516J A Sutherland Inc · Ukiah, CAN3052FHofer Belik Colleen J · Sawyer, NDN3052YPingston Anthony · Plymouth, MIN30530Banegas Jose C Zankiz · Fort Myers, FLN3053FBirkhold Craig Alan · Napoleon, OHN3053YMudd Joseph A · Oakland, CAN30549Lad Custom Publishing Inc · Buford, GAN3054FAirlaska LLC · Gustavus, AKN3056BO'Brien Alan S · Camarillo, CAN3056YBardack Barry L Trustee · El Cajon, CAN3057BRobins Jack S · Kaysville, UTN3057QJoseph C Casey · Lufkin, TXN3057YJjm Aviation LLC · Newport, NCN30583Roviaro Edward · Schererville, INN3058BUpper Limit LLC · Big Lake, AKN30593Valiair Lc Trustee · Casper, WYN305DKWashington State Patrol · Olympia, WAN305FStockdale Aviation LLC · Crawford, CON305JRHarrison Aviation LLC · Salem, ORN305KWPumpkin Eater LLC · Tavares, FLN305PYUfly Vi LLC · St Thomas, VIN305RCWashington State Patrol · Olympia, WAN305WAMy Way Aviation LLC · Weston, FLN305WBCardinal Aviation LLC · Charles City, VAN3060QYarg Tap LLC · Midland, TXN3061FTaber Deane W · Weirsdale, FLN3062FJohnson Sean D Trustee · Fresno, CAN3063FT J Croach Llp · Post Falls, IDN30644Registered aircraftN3064BSouthern Aircraft Consultancy Inc Trustee · Casper, WYN3064YStemper Pete L · Madison, SDN3065FHinds Frank E · San Angelo, TXN3065QSuchy Michael R · Murrieta, CAN3066QMeyer Vernon C · Westlake, LAN3067BImwalle John N · Batavia, OHN3067EGlass Bruce D · Crystal Lake, IL
Back to AD 84-10-01 R1