Skip to content

Registered aircraft · 321

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 ('1151544', '1151542')
  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 ('1151544', '1151542')
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.

N8093RBrand David E · Touchet, WABuilt 1969 · S/N D-8996 N8115RRegistered aircraftBuilt 1969 · S/N D-9003 N816NMidwest Aircraft Inc · Wilmington, DES/N D-8963 N81JBWeinstein Berthold W · Livermore, CABuilt 1968 · S/N D-8748 N827WCustom Air Inc · Roe, ARBuilt 1968 · S/N D-8743 N8300NErect A Tube Inc · Harvard, ILBuilt 1968 · S/N D-8719 N8309NNewman Michael Jay · Sherborn, MABuilt 1968 · S/N D-8720 N8318NAir Power Associates LLC · O Fallon, MOBuilt 1968 · S/N D-8723 N8321NAstle John K · Brighton, MIBuilt 1968 · S/N D-8722 N8325NKontour Shawn K · Wheatland, WYBuilt 1968 · S/N D-8730 N8326NLimitless Experience Inc · Middletown, DEBuilt 1968 · S/N D-8728 N8328N789 Aviation LLC · Medina, OHBuilt 1968 · S/N D-8735 N8332NMoon Kai LLC · Laguna Niguel, CABuilt 1968 · S/N D-8740 N8336NDejong James D · Doon, IABuilt 1968 · S/N D-8737 N8337NLivesay Gregory K · Mckinney, TXBuilt 1968 · S/N D-8739 N8339NMekolik Aaron S · College Station, TXBuilt 1968 · S/N D-8746 N8343NWavra Mark F · East Grand Forks, MNBuilt 1968 · S/N D-8741 N8353NLindahl Jonathan · Cary, ILBuilt 1968 · S/N D-8756 N8356NNielson Frederick P · Mesquite, NVS/N D-8744 N8358NQuam Contracting LLC · Creston, IAS/N D-8751 N8359NHendricks Flying Service LLC · Imperial, NEBuilt 1968 · S/N D-8753 N8360NYost Rawson · Watertown, SDBuilt 1968 · S/N D-8755 N8367NSearch Septic · Bailey, COBuilt 1968 · S/N D-8749 N8371NDecision Air Corp · Wilmington, DEBuilt 1968 · S/N D-8758 N8372NRudolph Pam G Trustee · Lake Havasu City, AZBuilt 1968 · S/N D-8759 N8378NBowler Joseph · Inglis, FLBuilt 1968 · S/N D-8760 N8389NSav Aviation LLC · Jacksonville, TXBuilt 1968 · S/N D-8774 N8392NCoats James Michael · Murrieta, CABuilt 1968 · S/N D-8775 N8393NJa Mar Flight Services Inc · Anderson, INS/N D-8776 N8395NLarocco John Jr · Michigan City, INBuilt 1968 · S/N D-8765 N8400NPhillips Roger Dale II · Westfield, NCBuilt 1968 · S/N D-8767 N8402NJones Dale H · Cookeville, TNBuilt 1968 · S/N D-8769 N8404NHidy Claude W · Stratton, NEBuilt 1968 · S/N D-8770 N8405NSpaziani Thomas F · Flagstaff, AZBuilt 1968 · S/N D-8771 N840PRegistration Pending · Onsted, MIRegistration pendingBuilt 1968 · S/N D-8797 N8419NSachau David W · Olathe, KSBuilt 1968 · S/N D-8784 N8420NHardy Robert C · Austin, TXS/N D-8773 N8421NFagan Dan III · Murfreesboro, TNBuilt 1968 · S/N D-8785 N8423NFarnham Dale E · Ames, IABuilt 1968 · S/N D-8787 N8425NWoods Aviation LLC · Fillmore, ILBuilt 1968 · S/N D-8790 N8428NAlexander Robert W · Knoxville, TNBuilt 1968 · S/N D-8788 N8441NBeasley Marty J · Statesboro, GAS/N D-8789 N8449NNms Air LLC · Kalamazoo, MIBuilt 1968 · S/N D-8794 N8452NGottsch Joe · Salem, ORBuilt 1968 · S/N D-8808 N8457NSharon Enterprises LLC · Peralta, NMBuilt 1968 · S/N D-8809 N8459NContrail LLC · Deerfield Beach, FLBuilt 1968 · S/N D-8796 N8463NDc Executive Aviation LLC · Spring, TXBuilt 1968 · S/N D-8798 N8466NFrancois Paul · Aurora, COBuilt 1968 · S/N D-8800 N8478NMclenaghan Alvin N · Phoenix, AZBuilt 1968 · S/N D-8805 N8483NFletcher Greg S Trustee · Grove, OKBuilt 1968 · S/N D-8807

Back to Beech V35A