Skip to content

Registered aircraft · 371

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 ('1220801')
  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 ('1220801')
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.

N1005ESemaska Victor J · Kensington, CTBuilt 1977 · S/N 299-77 N100DPEskind Thomas O Jr · Dallas, TXBuilt 1973 · S/N 130-74 N1046ERisk Indemnification Professionals LLC · Boston, MABuilt 1977 · S/N 296-77 N107AWDust Donald E · London, OHBuilt 1978 · S/N 474-79 N1083EDavis Gregory P · Olathe, KSBuilt 1977 · S/N 307-77 N1091EGlatthaar Richard J · Burbank, WAS/N 308-77 N1093EHanna Mark J · Orange, CAS/N 320-77 N1106ESlavens Timothy W · Howard City, MIBuilt 1977 · S/N 300-77 N1110ERegistration Pending · Hanford, CARegistration pendingBuilt 1977 · S/N 302-77 N1117ELocke Mason · Cloudcroft, NMBuilt 1977 · S/N 303-77 N1119ECole Jack A · Sun City West, AZBuilt 1977 · S/N 309-77 N1126EPatch Aero LLC · Boca Raton, FLS/N 306-77 N1155EN1155e LLC · Houma, LAS/N 311-77 N1159ERegistration Pending · Sherwood, ORRegistration pending, canceledBuilt 1977 · S/N 312-77 N11680Adams Jonathan · Columbia, MOBuilt 1972 · S/N 21-72 N11707Catfish Express Inc · Inverness, MSBuilt 1972 · S/N 15-72 N1175ENannini Gary S · Lincoln City, ORBuilt 1977 · S/N 314-77 N11870Owens Eric D · Garland, TXBuilt 1972 · S/N 12-72 N11BWQuonset Aviation LLC · North Kingstown, RIBuilt 1978 · S/N 434-78 N11MFCroom Aviation LLC · Port Saint Joe, FLBuilt 1972 · S/N 9-72 N1218EShibakov Alexander Y · Gainesboro, TNBuilt 1977 · S/N 324-77 N1223EBatzer Chad M · Pewaukee, WIBuilt 1977 · S/N 325-77 N124MCMonteleone Gene R · Mont Vernon, TXBuilt 1979 · S/N 502-79 N12KDDeeble Kenneth M · Dayton, MTBuilt 1979 · S/N 596-80 N130VUSwords Kyle · New Albany, MSBuilt 1975 · S/N 180-75 N133JFWindsock Capital LLC · Bertram, TXBuilt 1973 · S/N 73-73 N135DLOver And Under Flying Service Inc · Knox, INS/N 3372 N13PMFly High Aviation LLC · Melrose Park, ILBuilt 1977 · S/N 305-77 N146MCGibson William V · Aberdeen, MSS/N 54-73 N151VJonathan Wise & Associates Inc · Edmond, OKBuilt 1979 · S/N 550-79 N1691NFletcher Flying Service 419 LLC · Labelle, FLBuilt 1972 · S/N 18-72 N180SDMoore Philip R · Thompsons Station, TNBuilt 1975 · S/N 219-76 N205MAWarbird Adventures Inc · Ocoee, FLBuilt 1979 · S/N 530-79 N214CMKentucky Fly Boys Aviation LLC · Vine Grove, KYBuilt 1978 · S/N 372-78 N215RVJet & Rotor Aviation LLC · Sacramento, CABuilt 1973 · S/N 67-73 N21FTNordhaus Ronald R · Ottawa, OHBuilt 1973 · S/N 104-73 N222CAMorse Leonard R Trustee · Cottage Grove, ORBuilt 1972 · S/N 29-72 N226BFRichmond Charles H · Denison, TXS/N 7-72 N227ACBoeger Cade Patrick · Oroville, CABuilt 1977 · S/N 335-77 N229BBKidd Clifford L · Monahans, TXBuilt 1978 · S/N 466-79 N238DMCopeland Gary L · Williamsburg, MIBuilt 1972 · S/N 19-72 N2502ZByrne Gary W DBA · Georgetown, INBuilt 1977 · S/N 328-77 N2505ZStratton Robert Stephen · Boulder, COBuilt 1977 · S/N 330-77 N2509ZKovach Kim A · Ocala, FLS/N 333-77 N2512ZPlane Old Fun LLC · Mckinney, TXBuilt 1977 · S/N 334-77 N2523ZBchr Aviation LLC · Boerne, TXBuilt 1977 · S/N 337-77 N2524ZEgan Brian M · Saint Charles, ILBuilt 1977 · S/N 338-77 N2538ZSnell Marion Lea · Ackerly, TXBuilt 1977 · S/N 342-77 N253CAJtv Enterprises LLC · Painesville, OHBuilt 1977 · S/N 339-77 N2542ZGreenway Jonathan J · Frederick, MDBuilt 1977 · S/N 344-77

Back to Bellanca 8KCAB