AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N6416USt Marie Jack W · Encinitas, CAN64173Training Planes LLC · Tampa, FLN64174Sen Air Inc · Mckeesport, PAN6417JChapman Michael K · North Salt Lake, UTN6417RBogey Aviation LLC · Piqua, OHN64180Spanaflight LLC · Puyallup, WAN64181Christiansen Aviation LLC · Wilmington, DEN64184Arlington Flight Services Inc · Arlington, WAN64186Paraloft LLC · Mims, FLN6418DAirways Aviation Inc · Grand Rapids, MNN6418ELima-001 LLC · Muscatine, IAN64191Flycarolina LLC · Concord, NCN64192Skyhawk Transport LLC · Hazel Green, ALN64198Randy Goering Inc · Bend, ORN64199Mutschler George Robert Jr · Bayfield, CON6419JMathis Charles D · Carrollton, GAN6419LHaag Jay E · Mason City, IAN6419MWings Over Texas Holdings LLC · Denton, TXN6419PHelisur USA LLC · Pembroke Pines, FLN6419QFranklin Brian K · Lakewood Ranch, FLN6419VUrbana Aircraft LLC · Urbana, MDN641BStoddard Robert James · Brush Prairie, WAN641BBJones Legal Holdings LLC · Pikeville, KYN641CBBrownd Carl L · Tucson, AZN641CCClub Cherokee Inc · Crystal, MNN641DHFisher Russell D · Vacaville, CAN641FTFlorida Institute Of Technology · Melbourne, FLN641GWSnyder Jerry W · Greybull, WYN641HYGerges Amir · Arlington, TXN641JMDubose Mack H · Edmonds, WAN641MAAscent Aviation Inc · Duluth, MNN641NDUnd Aerospace Foundation · Grand Forks, NDN641PPhilip Mark A · Leesburg, VAN641PSSmith Michael J · Napa, CAN641PTPapa Tango LLC · West Monroe, LAN641RHJakes Guide Service LLC · Willow, AKN641RVDavies Chris D · Caddo Mills, TXN641SManning Robert S · Rosamond, CAN641SPRhode Island Air LLC · Providence, RIN641TDDornseif Keith · Merrillville, INN641THN641th Corp · La Quinta, CAN64201Registration Pending · Lander, WYRegistration pendingN64203Vance Nicholas D · Bluffton, OHN64209Kay Roland C · Wasilla, AKN6420JPomerenke Tyler J · Fairmont, MNN6420MJensen Aviation Inc · Zephyrhills, FLN6420QKelley Richard E · Spring Branch, TXN6420ULambert Glen C · Las Vegas, NVN6420VKorson James · Yorkville, ILN64213Ajc Aviation LLC · Boca Raton, FL
Back to AD 81-18-04 R2