OpenAirDocs.org
Lafayette, LA

Registered aircraft · 270

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'LA' AND g.registrant_city = 'LAFAYETTE'
  ORDER BY g.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.

N100ULCessna A150M · S/N A1500634Built 1976 · Evans Hugh EN102DRCessna 551 · S/N 551-0436Built 1982 · Cloud 9 LLCN103FPColumbia Aircraft Mfg LC42-550FG · S/N 42512Built 2006 · Style Ventures LLCN1081KBell Helicopter Textron 206L-1 · S/N 45407Built 1980 · Marks Aviation Group LLCN112EPBell 206L-3 · S/N 51612Marks Aviation Group LLCN113RLBell 206B-III · S/N 3306Built 1981 · Marks Aviation Group LLCN114SGRockwell International 114A · S/N 14535Built 1979 · Mixon Christopher LN11777Monocoupe 90A · S/N A706Built 1935 · Lerille RedN11797Monocoupe 90A · S/N A-721Built 1937 · Lerille RedN11PFDehavilland DHC-2 MK.I · S/N 1204Built 1958 · Texas Vessels Limited LLCN1208ZBeech 95-55 · S/N TC-60Built 1961 · Maurice L Prince Jr PcN1268BLuscombe 8A · S/N 5895Built 1947 · Lill Stephen PN1269EColumbia Aircraft Mfg LC42-550FG · S/N 42522Built 2006 · Destin Operating Co IncN12DHPilatus PC-12/47E · S/N 1210Built 2010 · Clear Skies LLCN131MJCessna 525B · S/N 525B0097Built 2006 · Eagle Aero IncN13346Cessna 172M · S/N 17262688Built 1973 · Stafford Cessna 13346 An LLCN1337BLuscombe 8E · S/N 5964Lerille Mark JN134SMBeech D-45 · S/N BG-312Built 1957 · Czech Six LLCN139DFAero Vodochody L-39 · S/N 132121Built 1981 · Czech Six LLCN139PHAgusta Aerospace AW139 · S/N 41253Phi Aviation LLCN140PHAgusta Aerospace AW139 · S/N 41254Built 2010 · Phi Aviation LLCN141PHAgusta Aerospace AW139 · S/N 41266Phi Aviation LLCN142DPBell 206L · S/N 45585Built 1980 · Marks LloydN144JJRobinson Helicopter R44 · S/N 0689Built 1999 · Qcp Group LLCN146PHAgusta Aerospace AW139 · S/N 41280Built 2011 · Phi Aviation LLCN149PHAgustawestland Philadelphia AW139 · S/N 41303Built 2012 · Phi Aviation LLCN14KKAviat A-1 · S/N 1272Built 1994 · Beachrock Logistics LLCN151PHAgustawestland Philadelphia AW139 · S/N 41312Built 2012 · Phi Aviation LLCN152PHAgustawestland Philadelphia AW139 · S/N 41316Built 2012 · Phi Aviation LLCN153PHAgustawestland Philadelphia AW139 · S/N 41317Built 2012 · Phi Aviation LLCN161CEEmbraer Executive EMB-500 · S/N 50000274Built 2012 · Diamond Z Aviation LLCN16427Monocoupe 90A · S/N A-754Built 1937 · Lerille RedN17238Bell 206L-3 · S/N 51492Built 1991 · Bennett Aviation LLCN17687Monocoupe D145 · S/N D-128Built 1941 · Lerille RedN1795RCessna A185F · S/N 18502511Built 1974 · Broussard Kenneth JohnN18184Monocoupe 90A · S/N A-810Built 1941 · Lerille RedN181CCCirrus Design SR22T · S/N 2017Built 2019 · Legacy Air Services LLCN181GCessna S550 · S/N S550-0006Mid South Agricultural Products IncN182AABell 206B · S/N 2752Built 1979 · Industrial Helicopters LLCN190RBReed R/Reed M AIR COMMAND TANDEM · S/N 1001RBCBuilt 1994 · Reed RoderickN192PHSikorsky S-92A · S/N 920021Built 2005 · Phi Aviation LLCN19437Monocoupe 90A · S/N A-787Lerille RedN197CVMooney International M20U · S/N 32-0001Built 2016 · Joseph F Gaar Jr Professional Law CorpN197DBCessna T310R · S/N 310R1809310 Flyers LLCN198HBell 206B · S/N 3647Built 1982 · Industrial Helicopters LLCN198MABell 206B · S/N 753Built 1972 · Marks Aviation Group LLCN2017WBeech 95-C55 · S/N TE-12Built 1965 · Ducharme Paul QuinN2061UBeech 95-B55 (T42A) · S/N TC-2202Built 1979 · Gulf Coast Camp LLCN210SDCessna T210N · S/N 21064225Built 1980 · Ardoin Robin CN212MDChapton Don RV7 · S/N 72773Built 2007 · Washington Donald W
Back to Lafayette, LA