Skip to content

Registered aircraft · 913

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

N6653DWilliams Lee V · Dallas, TXS/N D-10256 N6653RRegistered aircraftBuilt 1979 · S/N D-10259 N6653VWalker Ray A · Sanger, TXBuilt 1979 · S/N D-10253 N6654RLow Mach Aero LLC · Hays, KSBuilt 1979 · S/N D-10273 N6656RHarris Walter D · Chatham, NJBuilt 1979 · S/N D-10275 N6658DThietten Gary L Trustee · Washington, UTBuilt 1979 · S/N D-10312 N6658KEdelman Freddie L · Manlius, NYBuilt 1979 · S/N D-10278 N6659LControl Data Inc · Indianapolis, INBuilt 1979 · S/N D-10279 N6662HIrwin Dennis · San Diego, CABuilt 1979 · S/N D-10290 N6662TSeipp Edwin A III · Portola Valley, CABuilt 1979 · S/N D-10284 N66648Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N D10289 N6665ZDunkley Music Inc · Meridian, IDBuilt 1979 · S/N D-10291 N666WFFehlhaber Wolfgang M · Port Orange, FLBuilt 1976 · S/N D-9885 N6670JMccracken Scott D · Maysville, OKBuilt 1979 · S/N D-10295 N66818Schultz Gregory L · Greenbush, MNS/N D-10310 N6683DRegional Consultants LLC · Wilmington, DEBuilt 1979 · S/N D-10311 N6685RGlobal Distillation Services LLC · Reno, NVBuilt 1979 · S/N D-10314 N66876Mcmarlin Richard C · Santa Fe, NMBuilt 1979 · S/N D-10316 N6688EHill Daniel DBA · Grove, OKBuilt 1979 · S/N D-10319 N6688JQuesnel Robert Todd · Tomball, TXBuilt 1979 · S/N D-10299 N6688UHotel Lima LLC · Oro Valley, AZBuilt 1980 · S/N D-10320 N6689JAce Technical Services LLC · Hernando, MSBuilt 1979 · S/N D-10321 N668ZSDrumwright Gerald L · Ormond Beach, FLBuilt 1979 · S/N D-10258 N66907Flynn Curtis J · Granbury, TXBuilt 1979 · S/N D-10322 N66916Technet Aviation LLC · Charlotte, MIS/N D-10327 N6695HMegan Anderson Nursing Services Inc · Yucaipa, CABuilt 1980 · S/N D-10343 N6696WClift William R II · Princeton, KYBuilt 1980 · S/N D-10329 N66WCWeiner Ronald I · Jackson, TNBuilt 1978 · S/N D-10199 N6728YDashdale Aviation LLC · Fort Dodge, IABuilt 1980 · S/N D-10330 N6731RHaidlen Ford Inc · Oakdale, CABuilt 1980 · S/N D-10331 N6746BMoran Ted B · Spokane, WABuilt 1980 · S/N D-10344 N6747ZMclouth Fred E · Elkhorn, NEBuilt 1980 · S/N D-10346 N675BWFreedman Stephen Eric · Falls Church, VABuilt 1978 · S/N D-10134 N678JREberhardt John R Jr · Katy, TXBuilt 1977 · S/N D-10095 N67DRLarson Jeffrey · Spearfish, SDS/N D-9772 N6801SMastropole James W · Great Falls, VABuilt 1976 · S/N D-9849 N6808SKlw Flight Management LLC · Booneville, MSS/N D-9852 N6821SSouthern States Aircraft LLC · Walland, TNBuilt 1976 · S/N D-9853 N6831SJordan David N Jr · Knoxville, TNBuilt 1977 · S/N D-9971 N6999N3v1 LLC · Pensacola, FLBuilt 1975 · S/N D-9815 N69LJGonzalez-Ceballos Lorena Isabel · Haw River, NCS/N D-9692 N69XGHahn Curtis D · Saint George, UTBuilt 1976 · S/N D-9859 N6THDouble I Flyers Inc · Wilmington, DEBuilt 1974 · S/N D-9622 N700EDMcd Aviation Inc · Wilmington, DEBuilt 1972 · S/N D-9372 N703THall Charles M · Lubbock, TXBuilt 1975 · S/N D-9816 N707RDJones Alonzo · Los Angeles, CABuilt 1974 · S/N D-9708 N70DRLanzillo Joseph H · Lancaster, PABuilt 1979 · S/N D-10224 N70MEAmsdell David A · Morgantown, WVBuilt 1978 · S/N D-10123 N70MVDawson Asset Management And Consulting LLC · Edgartown, MABuilt 1979 · S/N D-10222 N711KMRegistration Pending · Cologne, MNRegistration pendingBuilt 1970 · S/N D-9106

Back to Beech V35B