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.
N8826DSongster Kevin M · Friend, NEN8826NWg Aviation LLC · Shippenville, PAN88273Pettijohn Patton D · Wasilla, AKN88276Straten Oliver · Wasilla, AKN88277Reid Paul E · Firth, IDN88278Crosswell Joe D · Springtown, TXN88280Lazareanu Sorin D · Apex, NCN88281Auten James W · Stratford, CTN88287Meyerkorth Aviation LLC · Rock Port, MON88288Cain Philip K · Escondido, CAN8828FJohnson Martin L · Agua Dulce, CAN8828YConard Thomas M III · Huntsville, ALN88290Outer Banks Seaplanes LLC · Manteo, NCN88297Naber David Lowell · Fairbanks, AKN8829CJohnson Steven D · Pardeeville, WIN8829DSchwenninger Ronald L · Allison Park, PAN8829WDernbach Richard M · Glenbrook, NVN882ATDot Aviation LLC · Wilmington, DEN882BKRegistered aircraftN882CPCivil Air Patrol · Maxwell Afb, ALN882EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN882FDrb Helicopters LLC · Klamath Falls, ORN882GHunt David Gregory Trustee · San Diego, CAN882JDSanders Flight Training Center Inc · Jasper, ALN882JHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN882KMMatheny Robin M · Titusville, FLN882LAAircraft Holdings LLC · Mesa, AZN882LBArizona Flyers Club Inc · Tucson, AZN882MASmith David E · Green Valley, AZN882PDEdwards Charles Steve · Fowler, KSN882RVCrissinger William M · Carl Junction, MON882SPRegistration Pending · Santa Fe, NMRegistration pending, canceledN882TCChristiansen Aviation LLC · Wilmington, DEN882WPSouth Florida Oasis LLC · Weirsdale, FLN88303Airplanes LLC · Springfield, ORN88305Loprinze Aviation LLC · Nashua, NHN88306Shaw David H · Nenana, AKN88307University Of Alaska Anchorage Aviation Technology · Anchorage, AKN88309Larkin Edward C · Covington, KYN8830JAnderas Per R · Green Bay, WIN8830LKolb Austin · Phoenixville, PAN8830PCanon Daniel H · Fruit Cove, FLN88311Nelson Jayson L · Glasgow, MTN88312Bayou Dusters LLC · Moreauville, LAN88314N88314 LLC · Louisville, CON88315Uscola Merle J · Wasilla, AKN88319Skyhunter Aviation LLC · Novi, MIN8831BBergeson Michael S · Cottage Grove, MNN8831CWright Michael · Hurricane, UTN8831MMcmeekin Robert R Jr · Bethesda, MD
Back to AD 81-18-04 R2