Skip to content

Lancair LC41-550FG

Registered aircraft · 122

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

N1024ZAqua Men Service LLC · Temple, GABuilt 2005 · S/N 41097 N104PPToledo Public Schools · Swanton, OHS/N 41086 N131MWFarina George · Killen, ALBuilt 2004 · S/N 41021 N139DCLegacy Air LLC · Missoula, MTBuilt 2005 · S/N 41056 N144LCPruetts Food Inc · Broken Bow, OKBuilt 2004 · S/N 41019 N150LCLipoff Jay I · Sarasota, FLBuilt 2005 · S/N 41501 N169HTAerie Leisure Inc · Phoenix, AZBuilt 2005 · S/N 41054 N169PJBernard Douglas A · New Iberia, LABuilt 2005 · S/N 41065 N209DWWhite Columbia Inc Trustee · Wilmington, DEBuilt 2005 · S/N 41504 N212TJ212tj LLC · Monterey, CABuilt 2004 · S/N 41038 N221WBOtter Rock Aero LLC · Newport, ORBuilt 2005 · S/N 41091 N222BYRda Solutions LLC · Fort Worth, TXBuilt 2004 · S/N 41022 N227SMIpme Management Corp · Jefferson, GABuilt 2004 · S/N 41011 N230SX2z West LLC · Alpine, WYBuilt 2004 · S/N 41045 N234KTCessna 182 LLC · Kitty Hawk, NCBuilt 2004 · S/N 41023 N236RSSchoombee Clinton John · Murrieta, CABuilt 2004 · S/N 41003 N23KPSp Aviation Inc · Hayward, CABuilt 2004 · S/N 41004 N240AFColumbia Av8ors Inc · Dover, DEBuilt 2005 · S/N 41525 N244DOlympia Hangars LLC · Tumwater, WABuilt 2005 · S/N 41096 N245DBVangundy R Eric · Chapin, ILBuilt 2005 · S/N 41102 N247DMGrimmett Lester · Clinton, MSBuilt 2005 · S/N 41506 N2500TJ & C Holdings Inc · Laguna Beach, CABuilt 2004 · S/N 41026 N2507LSimply Southern N2507l LLC · Fayetteville, GABuilt 2005 · S/N 41106 N2509WDouble D'S LLC · Massillon, OHBuilt 2005 · S/N 41061 N2511GVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41101 N2511YPrieur Philip · Suwanee, GABuilt 2005 · S/N 41060 N2514FVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N 41093 N2515BIndependent Columbia Aviators LLC · Katonah, NYBuilt 2004 · S/N 41040 N2518HHakan Michael · Carpinteria, CABuilt 2005 · S/N 41079 N251DXFlight Advantage Inc · Hot Springs, ARBuilt 2005 · S/N 41068 N2520CKrause Douglas R · Hinckley, OHBuilt 2005 · S/N 41516 N2520SPeregrine Air LLC · Colorado Springs, COBuilt 2005 · S/N 41073 N2521WPc Enterprise Holdings LLC · Penfield, NYBuilt 2005 · S/N 41514 N2522FGentrius LLC · Austin, TXS/N 41049 N2522SEagleray Design LLC · Burlington, VTS/N 41083 N2524GTgc Aviation LLC · Houston, TXBuilt 2005 · S/N 41515 N2526BTimd Group USA Inc · Cheyenne, WYBuilt 2005 · S/N 41105 N2526LQuest Aero LLC · Zeeland, MIBuilt 2004 · S/N 41035 N2527ZQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 41502 N25281Relair LLC · Conesus, NYBuilt 2005 · S/N 41088 N2528DOlson Michael S · Ellsworth, KSBuilt 2005 · S/N 41523 N2528TN2528t LLC · Norcross, GABuilt 2004 · S/N 41029 N2528ZRothermel Aviation LLC · Klingerstown, PAS/N 41055 N2529PMatera Management LLC · Spanish Fork, UTBuilt 2005 · S/N 41521 N2533KDomicile Capital LLC · Monterey, CABuilt 2005 · S/N 41531 N2535LK & L Adventures LLC · Moses Lake, WABuilt 2005 · S/N 41082 N25367Robinson Stephen C · Garrison, NDBuilt 2005 · S/N 41503 N2538MWarren James Rent · Rapid City, SDBuilt 2005 · S/N 41081 N2540MGlobal Emergency Services LLC · Beaumont, TXS/N 41031 N2541AEnergy307 LLC · Casper, WYBuilt 2005 · S/N 41085

Back to Lancair LC41-550FG