Skip to content

Registered aircraft · 68,375

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:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') 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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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:90-04-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
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.

N33WKilcourse Jeffrey K · Tequesta, FLBuilt 1990 · S/N 233 N33WAThompson Casey · Edmond, OKBuilt 1975 · S/N M-1619 N33WYOban Holdings LLC · Deephaven, MNBuilt 2010 · S/N 3094 N33XXPtacek Stephen R · Estes Park, COBuilt 1938 · S/N 14 N33YBBriggs Kent · Manhattan, KSBuilt 1963 · S/N 28-956 N33YYMoore Keith V · Germantown, TNBuilt 1966 · S/N 28-3230 N33YZJenkins Blake T · Lakeland, FLBuilt 1978 · S/N 24-0631 N33ZCMarker Michael M Jr · Los Lunas, NMBuilt 1987 · S/N 3 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 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 N34023Boyer Joseph S · Custar, OHBuilt 1941 · S/N 2874 N34029Rigdon William K · Hazel Green, WIBuilt 1970 · S/N 17701605 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 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 N3404ZDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1960 · S/N 22-7315 N34051Baker Sheryl W · Elbert, COBuilt 1941 · S/N 3006 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 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 N3407XAerodrome Aviation LLC · Brighton, COBuilt 1966 · S/N 1110

Back to AD 90-04-06 R1