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.

N103DBZelasko Edward P · Oxford, WIS/N A-86 N113WMStarke Charles H III · Weirsdale, FLBuilt 1966 · S/N A-114 N15AVRoquemore William A Jr · Lakeland, GABuilt 1966 · S/N A-154 N161LHJackson Donald R · Lexington Park, MDBuilt 1966 · S/N A161 N21DBStaton Riley J · Hayden, IDS/N A-232 N236FBPietrosemoli Castagni Andres · Cary, NCBuilt 1966 · S/N A-158 N4050JHampton Charles W · Marietta, OHS/N A101 N423LFChirtea John · Milton, DEBuilt 1965 · S/N A-15 N5300MArnold Jackson E · San Diego, CAS/N A-201 N5473ESitta Donald C · Farmington, NMBuilt 1965 · S/N A-7 N5476ENorth Fergus Flying Club · Winifred, MTBuilt 1965 · S/N A-10 N5477EVolatilis LLC · Wilmington, DEBuilt 1965 · S/N A-11 N5479ESurmick Chad C · Santa Rosa, CABuilt 1965 · S/N A-13 N5484EHarmon Daniel · Josephine, TXBuilt 1965 · S/N A-18 N5488ELancaster Kenneth B · Bremen, ALBuilt 1965 · S/N A22 N5582LHyr Inc · Hayward, WIS/N A-130 N55HELyon John D · Los Angeles, CABuilt 1965 · S/N A-23 N5600FBiehl Edgar A · Grove City, OHBuilt 1966 · S/N A-200 N5603FWoerle Edward R · Rossville, TNBuilt 1966 · S/N A-203 N5604FMcnamara Patrick E · Adams, TNBuilt 1966 · S/N A-204 N5606FCavu Aviation LLC · Cedar Park, TXBuilt 1966 · S/N A-206 N5609FGregory Vernon L · Swansea, SCBuilt 1966 · S/N A-209 N5612FWilliams Eddie R · Golden Valley, AZS/N A-212 N5614FKatzakian Trevor T · Lodi, CAS/N A-214 N5615FBalderston Daniel · Garden Grove, CABuilt 1966 · S/N A-215 N5616FHoak Edward C · Duncannon, PABuilt 1966 · S/N A-216 N5617FNiemi Fred H · Lake City, MIBuilt 1966 · S/N A-217 N5618FClanton Thomas I · Maryville, TNBuilt 1966 · S/N A-218 N5620FLight Sport LLC · Payson, AZBuilt 1966 · S/N A-220 N5621FBullock Robert · Mount Airy, MDBuilt 1966 · S/N A-221 N5624FGunsch Matthew T · Phoenix, AZBuilt 1966 · S/N A-224 N5625FWilson Bobby R · Kathleen, GABuilt 1966 · S/N A-225 N5629FShawn James Robert · Pattison, TXS/N A-229 N5631FHolladay Leonard R · Greeley, COS/N A-231 N5635FMartinez Jose A · Pensacola, FLS/N A-235 N5637FLong William M · Hemphill, TXBuilt 1967 · S/N A-237 N5638FFisk Christopher J · Hammonton, NJBuilt 1967 · S/N A-238 N5640FMcneill William F · Raeford, NCBuilt 1967 · S/N A-240 N5641FBogue Bruce E · Washington, MOBuilt 1967 · S/N A-241 N5642FTiger Flight Foundation Inc · Rome, GABuilt 1967 · S/N A-242 N5643FWoodhaven Air LLC · Blue Springs, MOBuilt 1967 · S/N A-243 N5652FHayden Robert P · West Fargo, NDBuilt 1966 · S/N A-152 N5653FCrowe James E · Sylvester, GABuilt 1966 · S/N A-153 N5659FMonske Nicholas J · Austin, TXBuilt 1966 · S/N A-159 N5663FHenley Enterprise Inc · West Palm Beach, FLS/N A-163 N5664FGiszterowicz Krzysztof · El Cerrito, CAS/N A164 N5669FEggers Michael Ryal · Colorado Springs, COBuilt 1966 · S/N A-169 N5670FSayles Curtis E · Seibert, COS/N A-170 N5672FBaker Donald N · Starkville, MSBuilt 1966 · S/N A-172 N5674FGregory Vernon L · Swansea, SCBuilt 1966 · S/N A-174

Back to Alon A2