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.
N7903PCaple Colby L · Windsor, CON7903VQuintas Frank · Palm City, FLN79040Higinbotham Larry L · Littleton, CON79042N79042 LLC · Rock Hill, SCN79048High Stakes Aviation LLC · Fresno, CAN7904CVaught Jon M · Stillwater, OKN7904GRight Rudder LLC · Rexburg, IDN7904WRobins Steven W · Franklinton, LAN79050Batto Jeannie L · Madison, INN79052Rose Gary A · Brighton, TNN79054N18228 Inc · Williamsburg, VAN79055Amies John W · Zimmerman, MNN79057First Eclipse Limited · Richmond, VAN7905PComanche250 LLC · Sequim, WAN7905YPatterson Thomas A · Minerva, OHN79060K&L Aviation LLC · Prosper, TXN79062Pierce Brenden D · Eatonville, WAN79063Sprague Todd K · Placerville, CAN79065Kingston Thomas P · Carmel, INN79066Doran Vincent J Jr · Wasilla, AKN79068Padgett Leonard Dale · Hobart, OKN7906HCarter Sheradon Royce · Sumner, TXN7906PCastro Johnny · Porterville, CAN7906SNeilsen James I · Waddell, AZN79071Cottrell Mark C · Leitchfield, KYN79072Registered aircraftN79079Jones Farm Fresh LLC · Bartlett, TNN7907LParker Daniel J · Ewing, NEN7907PSchwartz Tyson E · Midland, TXN7907WRegistration Pending · El Prado, NMRegistration pending, canceledN79081James Ferrick · Mechanicville, NYN79086Marshall County Flying Club Inc · Lacon, ILN79087Air Discovery La LLC · North Hollywood, CAN79089Ramaswamy Gautam · Clearwater, FLN7908GChamberlain Bruce H · Worcester, MAN7908LUSA Aircraft Leasing LLC · Dover, DEN7908WEmerald Coast Flying Club LLC · Fort Walton Beach, FLN79090Caughman John R · Katy, TXN79092Aero Quest LLC DBA · Olive Branch, MSN79093Bray Austin M · Pontotoc, MSN79095Hole In The Clouds Rentals LLC · Montgomery, ALN7909GCopass Kaneia · Fountain Run, KYN7909WCircus Of Six LLC · Wilmington, DEN790ASFly4fun LLC · Buffalo Grove, ILN790AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN790DWFairchild Ralph B · Wausau, WIN790FAAb Prop Plane II LLC · Metairie, LAN790FBEagle Aviation LLC · Fishers, INN790GKAirline Transport Professionals Corp Of USA · Wilmington, DEN790GWArbeitman Gordon · Ormond Beach, FL
Back to AD 81-18-04 R2