Skip to content

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

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

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.

N33ZDBentley Jeffrey W · Kenmore, WABuilt 2009 · S/N 71555 N33ZMUrban Timothy J · Laytonsville, MDBuilt 1966 · S/N 30-1044 N34005Hinckley David D · Belton, TXFirst renewal noticeBuilt 1970 · S/N 17701590 N3400AAirsmith Aviation LLC · Oshkosh, WIBuilt 1953 · S/N 22-1668 N3400GKirk John C · Bakersfield, CAS/N P-361 N3400WTop Flight Aircraft Holdings LLC · Dover, DEBuilt 1966 · S/N 32-261 N3400ZHojnacki Frank · Hobart, INBuilt 1960 · S/N 22-7311 N3401Lee Thomas D · Phoenix, AZBuilt 2012 · S/N 5764 N34011Cross Charles W Jr · Willoughby, OHBuilt 1970 · S/N 17701594 N34012Cap Flyers Aero Club LLC · Ocala, FLBuilt 1970 · S/N 17701595 N34014Rupp Gregory J · Deltona, FLBuilt 1976 · S/N 177RG0949 N34015Leftwich Brian · Savannah, GABuilt 1970 · S/N 17701597 N34019Kortum Ronald L · Williamstown, NJBuilt 1970 · S/N 17701599 N3401WAerial Crop Protection Inc · Belle Glade, FLBuilt 1954 · S/N 18-4064 N34029Rigdon William K · Hazel Green, WIBuilt 1970 · S/N 17701605 N3402WCw Baker Investments LLC · Baton Rouge, LABuilt 1965 · S/N 32-262 N34030Sommer Greg J · Maryville, ILBuilt 1976 · S/N 177RG0953 N34038B&B Cardinal LLC · Alexandria, VABuilt 1970 · S/N 17701608 N34039Snedeker Andrew · Jackson, NJBuilt 1976 · S/N 177RG0954 N3403PCarper Ryan W · Marietta, OHBuilt 1958 · S/N 23-1367 N3403WSchendel Daryl R · Barstow, CABuilt 1965 · S/N 32-264 N3403XWenkman Michael J · Madison, WIBuilt 1966 · S/N 1108 N3403ZCharpie Mark E · Ottawa Lake, MIBuilt 1960 · S/N 22-7314 N34041Lange Charles A · Portageville, MOBuilt 1970 · S/N 17701610 N34043Wrg Flyers LLC · Denver, COBuilt 1970 · S/N 17701611 N34045Ackerman Mark R · Box Elder, SDBuilt 1970 · S/N 17701612 N34049Osetek James · Harbor Springs, MIBuilt 1971 · S/N 17701616 N3404ALibby Stephen R Trustee · Anchorage, AKBuilt 1953 · S/N 20-1069 N3404THaik Kevin Jerome · Ozark, MOS/N 17700704 N3404XAero Nautical Electronics Inc · Starke, FLBuilt 1966 · S/N 1109 N3404ZSale Reported · Poulsbo, WASale reportedBuilt 1960 · S/N 22-7315 N34052Bauerle William L · Imperial, NEBuilt 1971 · S/N 17701617 N34058Dodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 177RG0956 N3405FGo Up High LLC · Grafton, WIBuilt 1967 · S/N 17700602 N3405XMurray Lacounte O · Leander, TXBuilt 1966 · S/N 3391 N3405ZHeinrich Steven A · Corvallis, ORBuilt 1960 · S/N 22-7317 N34063Sherman Stephen P · Prattville, ALBuilt 1976 · S/N 177RG0957 N34064Kupka John J · Okeechobee, FLBuilt 1971 · S/N 17701622 N3406WQwikflights LLC · Herriman, UTBuilt 1965 · S/N 32-267 N3406XThuerauf John E · Plum City, WIBuilt 1966 · S/N 3392 N34072Baden Aviation LLC · North Royalton, OHBuilt 1976 · S/N 177RG0960 N34077Registration Pending · Santa Monica, CARegistration pendingBuilt 1976 · S/N 177RG0961 N3407MBausch Wayne A · Ames, IABuilt 1947 · S/N 12-2253 N3407WYounkin Anthony · Ruffs Dale, PABuilt 1966 · S/N 32-299 N3407XAerodrome Aviation LLC · Brighton, COBuilt 1966 · S/N 1110 N3407ZBug Smashers LLC · Winfield, KSS/N 22-7319 N34080Rodell Justin A · Saint Paul, MNBuilt 1976 · S/N 177RG0963 N34081Danko James A · Norton, OHS/N 177RG0964 N34084Cardinal Aviation LLC · Eureka, MOBuilt 1976 · S/N 177RG0965 N3408TSpectron Aviation Inc · West Boylston, MAS/N 17700708

Back to AD 81-18-04 R2