Skip to content

Lancair LC-40-550FG

Registered aircraft · 64

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

N127DRKlamecki Alan P · Phoenix, AZBuilt 2001 · S/N 40028 N141AMMckendrick Ain · Redwood City, CABuilt 2002 · S/N 40038 N144AEMinard Stephan · Queen Creek, AZBuilt 2002 · S/N 40042 N156JBSully Air LLC · Atlanta, GABuilt 2001 · S/N 40019 N171TBMaritime Aviation Security Team · Wilmington, NCBuilt 2002 · S/N 40045 N173KTCrawford Chris M · North Dinwiddie, VAS/N 40035 N1KVParagon Aviation LLC · Greenland, NHFirst renewal noticeBuilt 2003 · S/N 40063 N21XCHeaton Joshua · Allen, TXBuilt 2000 · S/N 40007 N242PZFennell Louis A Jr · Johns Island, SCS/N 40037 N269GBG B A Aviation Inc · Wilmington, DES/N 40030 N26VVSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 40055 N284KBRoper Lawrence F Jr · Georgetown, SCS/N 40068 N29KK29kk LLC · Manchester, MIBuilt 2003 · S/N 40071 N300HMEngage Communication Inc · Aptos, CABuilt 2001 · S/N 40011 N300NVHolombo Lee C · Trenton, KYBuilt 2003 · S/N 40064 N300TLAlls Peyton H · Raleigh, NCBuilt 2003 · S/N 40067 N303LMRegistered aircraftBuilt 2002 · S/N 40041 N30LNRaymon Rodherick L · Enterprise, ALBuilt 2002 · S/N 40046 N323CLHoge John · Setauket, NYBuilt 2002 · S/N 40054 N378FJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 40076 N37BAAmbler Robert L · San Diego, CABuilt 2001 · S/N 40020 N385TWSheely Patrick D Trustee · Rapid City, SDS/N 40072 N501PFTraumflieger LLC · Lancaster, PABuilt 2001 · S/N 40021 N503RAAirplanes And Coffee LLC · Kalispell, MTBuilt 2001 · S/N 40024 N507NANasa Langley Research Center · Hampton, VABuilt 2000 · S/N 40008 N550GRClark Robert E · Meridian, MSBuilt 2001 · S/N 40015 N567MB1 And 3 Lc · Jenks, OKBuilt 2002 · S/N 40052 N590JGMark V Aviation LLC · Missoula, MTBuilt 2002 · S/N 40044 N615MPMorning Star Transportation Inc · Dardanelle, ARBuilt 2001 · S/N 40017 N616MSBledsoe Bobby H · Hot Springs, ARS/N 40047 N6500BAndrews Aviation LLC · Spartanburg, SCBuilt 2002 · S/N 40043 N6500LApsis Aviation LLC · Kentfield, CABuilt 2001 · S/N 40027 N6501MByrne William J · Davis, CABuilt 2001 · S/N 40023 N6503TRussell Construction Co · Douglas, WYBuilt 2002 · S/N 40039 N6504KQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 40062 N6505CLancair Leasing LLC · Greensboro, NCBuilt 2003 · S/N 40066 N6505LTheriot Conchita F · Anderson, SCBuilt 2001 · S/N 40033 N6508BTechnology Farm Inc · Tewksbury, MABuilt 2002 · S/N 40053 N65099Aguirre-Y-Luker Grant C · Santa Fe, NMBuilt 2003 · S/N 40075 N6511YToys LLC · Cumberland, RIBuilt 2003 · S/N 40073 N65123Martin Michael · Galesburg, ILS/N 40077 N6512FFunk Norman J · Norfolk, NEBuilt 2003 · S/N 40078 N6514BN2828 LLC · Highland, WIBuilt 2001 · S/N 40026 N717CWAmerican Flying Club Inc · Arlington, VABuilt 2001 · S/N 40025 N73TXSee Robert W · Catawba, NCBuilt 2001 · S/N 40034 N74CRCage Presnall C · Falfurrias, TXBuilt 2003 · S/N 40061 N75LBL & A Bennett Second Family Lp · Renton, WABuilt 2001 · S/N 40014 N761SRNikitin Alexey Pavlovich · Tigard, ORBuilt 2003 · S/N 40069 N777XXAustex Aviation Group Inc · Austin, TXBuilt 2002 · S/N 40058 N788WAnderson Harry R · Bainbridge Island, WABuilt 2001 · S/N 40022

Back to Lancair LC-40-550FG