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.
N56001Citabria LLC · Missoula, MTN56002Clark William · Gig Harbor, WAN56007N56007 LLC · Burke, VAN56008F R G III Inc DBA · Lincoln Park, NJN5600CRegistered aircraftN5600HGreen James H · Bladenboro, NCN5600JHigh Country Aircraft LLC · Westcliffe, CON5600MClarke Michael J · Baker, FLN5600QA & D Aviation LLC · Aberdeen, OHN5600UCorey Marlin F · Choctaw, OKN5600WFitzgerald Anthony M · Crete, NEN5600YNelson Kenneth A · Fort Mill, SCN56015Ac Sales & Investments LLC · Hickory, NCN5601GRetzlaff Cathy S · Oshkosh, WIN5601HPierce Stephan L · Graham, TXN5601LManheimer Robert M · Marysville, WAN5601PDevil Dusters Inc · Artesia, NMN5601QRegistered aircraftN5601WTaylor Larry J · San Manuel, AZN56023Bennett Paul · Phoenix, AZN5602JVarga Aircraft Co · Hephzibah, GAN5602QWacker Jeremy C · Denver, CON5602WSaunders Nathaniel E · Muskegon, MIN56031Musser John R · Freeport, ILN56032Umo Flight School LLC · Mount Olive, NCN56033Larson Douglas R · Goodyear, AZN5603LKushnir Borys G · Tamuning, GUN5603PLitteken David T · Aviston, ILN5603WElliot Harold F II · Pomeroy, OHN5603ZAngerman Ronald A · Gilbert, SCN56041Haddad Joe · Charlotte, NCN5604QSkywagons.Com LLC · Placerville, CAN5604UShumaker Grant H · Dakota Dunes, SDN5604WHustedde Trucking LLC · Fayette, MON56050Seidel Seth · Ellington, CTN56055Murray Patrick Calvin Jr · Port Orchard, WAN5605JMajor Air LLC · Charleston, SCN5605PAurnou Marshall E · Marco Island, FLN5605QBennett Steven D · La Fayette, GAN5605UN5605u LLC · Nottingham, NHN5605ZMossman Aaron P · West Plains, MON56063Powell James M III · Columbia, SCN56066Trojan Aviation LLC · Kailua Kona, HIN5606LJones Andrew S · Greensboro, GAN5607NEagle Services Inc · Washington, MIN5607UWilliams Richard Dale · Tucson, AZN5607WFrost Jack D II · Goodrich, MIN5607ZCorcoran Francis A · Rochelle, ILN56083Rock Solid Aviation LLC · Lake Charles, LAN56085Donohue John T · Big Bear Lake, CA
Back to AD 81-18-04 R2