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.
N694MLLindstrom Micah · Milaca, MNN694MPMohill Loren Dell · Murrieta, CAN694PBlack Robert · New Market, ALN694PKRule John H · Statesboro, GAN694PSSteger Paul M · Locust Grove, GAN694RRiley James L · Lakeville, MNN694RMTavel Charles · Cave Creek, AZN694RSSnarr Randy L · South Jordan, UTN694SAMile High Ventures Inc · Palm Harbor, FLN694SCAlpha Charlie Aviation LLC · Oregon City, ORN694SMSurveying And Mapping LLC · Austin, TXN694SPFox Leasing Group LLC · Hollywood, FLN694VHall Davis Warren · Mobile, ALN6950BLudwig Henry H · Fort Worth, TXN6950DFaught Jeffrey R · Bismarck, NDN6950KGerhold Jeremy R · Rosharon, TXN6950PRegistered aircraftN6950RJefferson Airplane LLC · Port Hadlock, WAN6950WEalp LLC · Evansville, INN6951PRossback Jason M · Denver, CON6952BWesley Jerry A · Moorland, IAN6952CSnoz Inc · Sharon, MAN6952HIronfield Jeffrey A · Livermore, CAN6952JLagimoniere Gregory · Jacksonville Beach, FLN6952KPoor Jeffrey L · Bettles, AKN6952PBretts Flying Service LLC · Mount Pleasant, MIN6952RMelville Isaiah · Panama City, FLN6952UDuggan Edwin T · Franklin, MEFirst renewal noticeN6952WBeaver Milton H II · Palmer, AKN6953DLambert Hubert D Sr · Lincolnton, NCN6953PCianciolo Philip H · Yakima, WAN6953QBrancefield John Lewis · Fort Mohave, AZN6953WScotting David R · Pipestone, MNN6954PJcav8 LLC · Cartersville, GAN6954QBalash Bryan J · Oldenburg, INN6954VGrubb Jefferson D · Chesapeake, VAN6955DGlover Thomas B · Marana, AZFirst renewal noticeN6956BBushplane Lab LLC · Wilderville, ORN6956JJuliet Sky LLC · Sioux City, IAN6956KEdwards Stephen L · Wasilla, AKN6956QStaab Robert J · Wantage, NJN6956RMorgan Richard D · Belton, TXN6956VAbney Timothy R · Crossett, ARN6957BVaughn James R · Winchester, KYN6957PHoran Edward · Wexford, PAN6957QWashburn Ronald G · Westfield, INN6957VKnoke Keith W · Litchfield Park, AZN6958HJewell Aviation Inc · Kennett, MON6958JAkin Enterprises Inc · Greensboro, GAN6958UVauclin Brady P · Shreveport, LA
Back to AD 81-18-04 R2