Skip to content

Registered aircraft · 144

Aircraft of this model in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN ('0540102')
  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, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN ('0540102')
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.

N5676FBrad S Jones LLC · Oak Hill, FLBuilt 1966 · S/N A-176 N5677FFarmer Jim D · Savannah, MOBuilt 1966 · S/N A-177 N5678FGregory Vernon L · Swansea, SCBuilt 1966 · S/N A-178 N5679FLong Mark B · Wichita, KSBuilt 1966 · S/N A-179 N5683FBrady Robert M · Shawnee, KSS/N A-183 N5684FRegistered aircraftBuilt 1966 · S/N A-184 N5685FRailton Joseph · Wadesboro, NCBuilt 1966 · S/N A-185 N5686FElling Jerrold A · Ladysmith, WIBuilt 1966 · S/N A-186 N5689FCarrell William G · Pittsburgh, PABuilt 1966 · S/N A-189 N5691FBahm Martin P · Edmond, OKBuilt 1966 · S/N A-191 N5692FSchneider Scott M · Tribune, KSBuilt 1966 · S/N A-192 N5694FAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1966 · S/N A-194 N5695FTiger Flight Foundation Inc · Rome, GABuilt 1966 · S/N A-195 N5697FWilson Myron L · Cut Bank, MTBuilt 1966 · S/N A-197 N5698FGriggs Joseph L · Murphy, NCBuilt 1966 · S/N A-198 N5699FGriggs Joseph L · Murphy, NCBuilt 1966 · S/N A-199 N5918FGregory Vernon L · Swansea, SCS/N A-213 N6353VDutch Ladybird LLC · Mayville, WIBuilt 1965 · S/N A-29 N6354VAdvanced Aircrew Training LLC · Nashua, NHBuilt 1965 · S/N A-30 N6355VNelson Lynn H · Frostproof, FLBuilt 1965 · S/N A-31 N6357VSelf Robert B · Blanchard, OKBuilt 1965 · S/N A-33 N6358VBurleson James R · Snyder, TXBuilt 1965 · S/N A-34 N6360VKato Matt J · Fairbanks, AKBuilt 1965 · S/N A-36 N6361VMcgowan Tim · Calhoun, GABuilt 1965 · S/N A-37 N6362VCarver Norman C · Gilbert, AZBuilt 1965 · S/N A-38 N6363VGregory Vernon L · Swansea, SCBuilt 1965 · S/N A-39 N6364VGregory Vernon L · Swansea, SCBuilt 1965 · S/N A-40 N6365VHoskins Marc R · Kennett, MOS/N A-41 N6366VCombs Ronnie M · Albany, MOBuilt 1965 · S/N A-42 N6370VWhite Berry · Runaway Bay, TXBuilt 1965 · S/N A-46 N6372VWhitcomb Keith R · Villa Rica, GABuilt 1965 · S/N A-48 N6373VKaichen Michael Trustee · Eliot, MEBuilt 1965 · S/N A-49 N6375VBarker Benjamin J · Pittsburg, NHBuilt 1965 · S/N A-51 N6500QGartland John J · Brooklyn Park, MNBuilt 1966 · S/N A-100 N6503QRathmann Arnold H · Hoffman Estates, ILBuilt 1966 · S/N A-103 N6504QKnutson Wayne R · Thompson, NDBuilt 1966 · S/N A-104 N6505QRegistered aircraftBuilt 1966 · S/N A-105 N6506QHogan Earle S Jr · Kenbridge, VABuilt 1966 · S/N A-106 N6508QShipley Ronald L · Lemon Grove, CABuilt 1966 · S/N A-108 N6511QBryant David A · Rosamond, CABuilt 1966 · S/N A-111 N6512QSmith Jess T · Willows, CABuilt 1966 · S/N A-112 N6513QFrank George W Jr · Evansville, INS/N A-113 N6515QHoward Roland L · Forsyth, MTBuilt 1966 · S/N A-115 N6516QHolt Dennis J · Leetonia, OHBuilt 1966 · S/N A-116 N6518QMaurer Sara A · Anchorage, AKBuilt 1966 · S/N A-118 N6522QPrice Richard H · Corryton, TNS/N A-122 N6525QMoore Robert Wayne · Brenham, TXBuilt 1966 · S/N A-125 N6526QRevette Richard L · Littleton, COBuilt 1966 · S/N A-126 N6527QSlifkin Lester H · Arcadia, CABuilt 1966 · S/N A-127 N6529QWill Peter J · Westminster, COBuilt 1966 · S/N A-129

Back to Alon A2