Skip to content

Registered aircraft · 40,473

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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N4413ZBlackcountry Flying Experience Inc · Kalispell, MTBuilt 1968 · S/N 18-8746 N44146Raimo Joseph H · New York, NYBuilt 1974 · S/N 28-7415591 N4414JHtf Aviation LLC · Kalispell, MTBuilt 1967 · S/N 28-22810 N4414XMellett Aircraft Inc · Ambler, PABuilt 1975 · S/N 28-7690005 N44156Gamelli James T · Bridgeport, WVBuilt 1974 · S/N 28-7405224 N4415ACanter Russell L · Enterprise, KSBuilt 1956 · S/N 22-3743 N4415RNextgen Flight Academy Inc · Riverside, CABuilt 1974 · S/N 17263163 N44167Sound Technology Matters LLC · Zeeland, MIBuilt 1974 · S/N 28-7415594 N4416AAltendorf Richard C · Northwood, NDBuilt 1956 · S/N 18-5161 N4416JBoone Paint & Interiors Inc · Boone, NCBuilt 1967 · S/N 28-22871 N44171Sanders Michael L Jr · Plainfield, INBuilt 1974 · S/N 28-7415595 N44176Taylor Wilbur J Jr · Oro Valley, AZBuilt 1974 · S/N 28-7415596 N4417JPalmatier Seth · Chandler, AZBuilt 1967 · S/N 28-22814 N44189Lane Robert C · Calico Rock, ARBuilt 1974 · S/N 28-7415598 N4418JS B Enterprise LLC · Marshall, TXBuilt 1967 · S/N 28-22815 N4418RTeton Leasing LLC · Pocatello, IDBuilt 1974 · S/N 17263166 N4418ZHigh Wind Aviation Service LLC · Ludlow, VTBuilt 1968 · S/N 18-8753 N44192Steere George O Jr · Chepachet, RIBuilt 1974 · S/N 28-7405226 N44193Brekhus Scotti · Cheyenne, WYBuilt 1974 · S/N 28-7405227 N44195Guthrie Aircraft Inc · Wadsworth, OHBuilt 1974 · S/N 28-7405228 N441ACAero Champ LLC · Orlando, FLS/N 401-97 N441AMFussell Aviation LLC · Mcrae-Helena, GABuilt 1966 · S/N 28-3688 N441BMMillsap Ted I · Redding, CAS/N 28-22816 N441DLPinion Aviation Inc · Glenbrook, NVBuilt 1976 · S/N 17267391 N441DPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1975 · S/N 17265691 N441FLJustice Carrie · Plano, TXBuilt 1971 · S/N 28-7125230 N441HGGeorgia Aviation Authority · Eastman, GABuilt 1995 · S/N 4496003 N44203Skyline Solutions Inc · Deland, FLBuilt 1974 · S/N 28-7415600 N4420JSilver Wings Aviation LLC · El Paso, TXBuilt 1967 · S/N 28-24067 N4420RPeterson Reid E · Minnetonka, MNBuilt 1974 · S/N 17263167 N4420TElsner Wayne C · Plymouth, WIBuilt 1972 · S/N 28-7225169 N4420ZRuff Gregory Z · Red Bluff, CAS/N 18-8756 N44218Bluebird Aero LLC · Wilmington, DEBuilt 1974 · S/N 28-7415603 N4421DHolt Reginald M · Ankeny, IABuilt 2000 · S/N 22055 N4421JFirst Flight LLC · Caledonia, MIBuilt 1967 · S/N 28-22819 N4421PAmendt Joseph J Jr · Watertown, SDBuilt 1960 · S/N 23-1935 N4421TKinman Kary W · Panama City Beach, FLS/N 28-7225170 N4421XN4421x LLC · Sarasota, FLBuilt 1975 · S/N 28-7690007 N44228Christophersen Hunter R · Fairway, KSFirst renewal noticeBuilt 1974 · S/N 28-7405231 N4422AHackwell Calvin · Enoch, UTBuilt 1956 · S/N 22-3751 N4422RN4422r LLC · Miami, FLBuilt 1974 · S/N 17263168 N44236Tanner Rhett D Jr · Livingston, LABuilt 1974 · S/N 28-7425396 N4423QObap · Westchester, ILBuilt 1973 · S/N 17261704 N44245Riter Robert M · Hereford, AZBuilt 1974 · S/N 28-7425397 N4424AHulme Randi M · Kimberly, IDBuilt 1956 · S/N 22-3753 N4424JSeaplane Adventures LLC · Cheyenne, WYBuilt 1967 · S/N 28-22824 N4424ZChmiel John E · Rhinelander, WIFirst renewal noticeBuilt 1969 · S/N 18-8761 N44253Bull Kenneth · Dania Beach, FLBuilt 1974 · S/N 28-7415610 N4425JReynolds Darryl G · Wills Point, TXBuilt 1967 · S/N 28-22825 N4425ZSale Reported · Quincy, WASale reportedBuilt 1968 · S/N 18-8762

Back to AD 80-04-03 R2