Skip to content

Registered aircraft · 1,065

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

N8240F14a Flying Club Inc · Mooresville, NCBuilt 1966 · S/N 15064340 N8245FMorisette Michael W · Antelope, CABuilt 1966 · S/N 15064345 N8246FTalikka Todd · Paulding, OHBuilt 1966 · S/N 15064346 N8247FCarson Leonard H · Chesapeake, VAS/N 15064347 N8248FLucia Steven R Sr · Agawam, MAS/N 15064348 N8250FRyan Good Aviation LLC · Sioux Falls, SDS/N 15064350 N8250SRegistration Pending · Statesville, NCRegistration pendingBuilt 1965 · S/N 15061850 N8253FSinclair Jerry D · Watonga, OKBuilt 1966 · S/N 15064353 N8255FStarks Aviation Inc · Pittsburgh, PAS/N 15064355 N8255SConz Gerald Patrick Jr · Wyandotte, MIS/N 15061855 N8257SCrews Bryce D · Rensselaer, INBuilt 1965 · S/N 15061857 N8259FCoker Nathan F Jr · Lynchburg, VABuilt 1966 · S/N 15064359 N8266FOnemanconcrete LLC · Thaxton, VABuilt 1966 · S/N 15064366 N8266SRankin Gregory E · Wetumpka, ALBuilt 1965 · S/N 15061866 N8267FPokorny John · Woodstock Valley, CTBuilt 1966 · S/N 15064367 N8268FBudd Jim · Rushville, NEBuilt 1966 · S/N 15064368 N8270SN83993 LLC · Cherry Hill, NJExpired dealer, pending cancellationBuilt 1965 · S/N 15061870 N8271SKontz Gary Lee · Canby, MNBuilt 1965 · S/N 15061871 N8272SVierheller Glenn Eric · Seville, OHBuilt 1965 · S/N 15061872 N8273FAir Charterz LLC · Columbus, OHS/N 15064373 N8274FMcclain Daniel S · Enon Valley, PAS/N 15064374 N8275FStanford Michael · Victoria, TXBuilt 1966 · S/N 15064375 N8278FIvey Joseph M · Poland, OHS/N 15064378 N8285FBearss Gordon M · Lawrence, KSBuilt 1966 · S/N 15064385 N8288SWatters Reid W · Tilleda, WIBuilt 1965 · S/N 15061888 N8289FDe Cristo Andre G · Flushing, NYBuilt 1966 · S/N 15064389 N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890 N8291SSipes Jacob L · Sunbury, OHBuilt 1965 · S/N 15061891 N8294FWalters Craig S · Lake City, FLS/N 15064394 N8294SLogtime Flight LLC · Lancaster, TXBuilt 1965 · S/N 15061894 N8297SBergmann Joshua A · Menomonie, WIBuilt 1965 · S/N 15061897 N8298FAustin Leslie M · Greenville, INBuilt 1966 · S/N 15064398 N8299SMcauliffe John P · Livonia, MIBuilt 1965 · S/N 15061899 N8302GLittle Air Dream LLC · Mooresville, NCBuilt 1965 · S/N 15062402 N8306GLees Michael S · Port Allen, LABuilt 1965 · S/N 15062406 N8307GRegistered aircraftS/N 15062407 N8308GThompson Stephen A · Murphy, NCBuilt 1965 · S/N 15062408 N8309GWoods Allen D · Old Hickory, TNBuilt 1965 · S/N 15062409 N8311GLockwood William E · Carmel, NYS/N 15062411 N8312GYampolskiy Dmitriy · San Pedro, CABuilt 1965 · S/N 15062412 N8315GNaisby Walter H · Harvey Cedars, NJBuilt 1965 · S/N 15062415 N8321GSilveria Clifford J · Humble, TXBuilt 1965 · S/N 15062421 N8323GRusso Dobye G · Clinton, OKBuilt 1965 · S/N 15062423 N8324GDexter Brady R · Chambers, NES/N 15062424 N832SRWallace John M · Canton, MSS/N 15062860 N8331GWhitley Jonathan K · Goldsboro, NCBuilt 1965 · S/N 15062431 N8332GFlack Kevin S · Woolford, MDBuilt 1965 · S/N 15062432 N8333GInvestair LLC · Conway, ARBuilt 1965 · S/N 15062433 N8334GAvcraft Inc · Columbus, NEFirst renewal noticeBuilt 1965 · S/N 15062434 N8337GSkyline Aviation Inc · San Angelo, TXBuilt 1965 · S/N 15062437

Back to Cessna 150F