Skip to content

Lancair LC42-550FG

Registered aircraft · 75

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

N101PMKasper John D · Oxford, ALBuilt 2004 · S/N 42055 N141PBL&M Columbia 181 LLC · Chandler, AZS/N 42066 N166DSJagar Holdings LLC · Fort Worth, TXS/N 42070 N16VABs LLC · North Vernon, INBuilt 2003 · S/N 42008 N1800HSanders Trent J · Redway, CABuilt 2003 · S/N 42009 N190DWSouthern Sky Ventures LLC · Lewes, DEBuilt 2003 · S/N 42002 N191DWLexo Enterpirses · Houston, TXBuilt 2003 · S/N 42022 N193DWGilbert Louis Vincent · Houston, TXBuilt 2004 · S/N 42043 N213LBPetro Larry D · Washington, DCBuilt 2004 · S/N 42051 N21MGVortex Aviation LLC · Lafayette, LABuilt 2003 · S/N 42034 N241EBUsd Flyers Inc · Atlanta, GABuilt 2005 · S/N 42065 N241GBPalmer Levi S · Upper Lake, CABuilt 2003 · S/N 42023 N244SCGiacometto John · Stevensville, MTBuilt 2004 · S/N 42047 N2502QMaxim Aviation LLC · Sugarloaf Key, FLBuilt 2005 · S/N 42076 N2506VLancestrom LLC · Tomball, TXS/N 42067 N2511XAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 42063 N2512XKeesee Theodore A · Lavonia, GABuilt 2005 · S/N 42077 N2517XBraun Robert M Trustee · Watkins, MNBuilt 2005 · S/N 42081 N2539ENimbus 2005 LLC · Glenview, ILBuilt 2005 · S/N 42078 N320DRMontgomery Machine LLC · Guilford, CTBuilt 2005 · S/N 42064 N350BLAustin Neal · Fort Myers, FLBuilt 2003 · S/N 42006 N350DGQualitair LLC Trustee · MichelstadtBuilt 2005 · S/N 42074 N350PGGuerra Michael E · Kerrville, TXBuilt 2003 · S/N 42005 N350RPShy Dennis · Cape Coral, FLBuilt 2004 · S/N 42046 N350SFTakamatsu Hiroaki · Redmond, WAS/N 42062 N361LBMiller Steven D · Edinburg, PABuilt 2003 · S/N 42010 N400TVA & A Farms Inc · Arbuckle, CABuilt 2004 · S/N 42041 N416TBMyers Hollis Donald III · Lexington, NCBuilt 2005 · S/N 42080 N468CLVicash LLC · Dover, DEBuilt 2003 · S/N 42030 N46HDPrice Jesse · Fargo, NDBuilt 2005 · S/N 42071 N495RDCapital Holdings 226 LLC · Naples, FLBuilt 2003 · S/N 42032 N518LSeehimfly LLC · Spring, TXBuilt 2003 · S/N 42028 N59MMPlane Fun Inc Tr Trustee · Snellville, GABuilt 2003 · S/N 42004 N628BBAmerican Lumber And Plywood Inc · Guntersville, ALBuilt 2005 · S/N 42073 N644STCohen Steven B · Safety Harbor, FLBuilt 2005 · S/N 42079 N6500GConsultant Services LLC · Stillwater, MNBuilt 2004 · S/N 42045 N6500VBlue Marble Aviation LLC · Center Valley, PABuilt 2003 · S/N 42033 N6501UMoses Hunter K · Georgetown, TXBuilt 2004 · S/N 42040 N6501ZJ&M Aviation Enterprises LLC · Greendale, WIBuilt 2003 · S/N 42007 N6502ABelair Two LLC · Lancaster, PABuilt 2004 · S/N 42048 N6502HSimpson Equipment Leasing LLC · Hays, KSBuilt 2004 · S/N 42037 N6502XFalcon Way Partners LLC · East Helena, MTBuilt 2004 · S/N 42039 N65031Miller Lewis W · Setauket, NYBuilt 2004 · S/N 42060 N65035Vimco Aviation LLC · El Paso, TXBuilt 2004 · S/N 42052 N6503CPotts Phillip G · Chattanooga, TNBuilt 2003 · S/N 42015 N65042Blueventure LLC · Morganton, NCBuilt 2004 · S/N 42042 N6504DAirmart Aircraft Holdings Inc · Oak Ridge, NCS/N 42035 N6504XMarc Pauls · Charlotte, NCBuilt 2004 · S/N 42056 N6504ZAlbertson Robbie H · Easley, SCBuilt 2003 · S/N 42024 N6505VElg Air LLC · Birmingham, ALS/N 42053

Back to Lancair LC42-550FG