Skip to content

Diamond Aircraft Ind DA 42

Registered aircraft · 114

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 ('2990104', '2990004')
  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 ('2990104', '2990004')
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.

N101DAFlying High Again LLC · Mount Juliet, TNBuilt 2006 · S/N 42.125 N108LUMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 42.307 N119BJFlight Stars Az LLC · Tempe, AZBuilt 2007 · S/N 42.AC045 N127USN127us LLC · Merrimack, NHS/N 42.AC127 N132TSUtah State University · Logan, UTBuilt 2006 · S/N 42.AC018 N149WTVectors To Final LLC · Columbus, OHFirst renewal noticeBuilt 2007 · S/N 42.AC046 N158TSMidwest Corporate Air Inc · Bellefontine, OHBuilt 2006 · S/N 42.137 N16ESMeow Meow LLC · Seattle, WABuilt 2007 · S/N 42.AC100 N16FAAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2007 · S/N 42.AC029 N176TSOld Glory Inc · Tulsa, OKBuilt 2006 · S/N 42.176 N188KUOak Street Properties LLC · Pratt, KSBuilt 2006 · S/N 42.AC020 N189YCerrit LLC · Helena, MTBuilt 2006 · S/N 42.AC033 N197TSTango Charlie Foxtrot LLC · Port Orange, FLBuilt 2006 · S/N 42.AC001 N198TSWorld Class Aviation Ltd · Bellefontaine, OHBuilt 2006 · S/N 42.AC002 N199TSWind Rising Ventures LLC · Columbus, MSBuilt 2006 · S/N 42.AC003 N212EKRegistered aircraftN-number assigned (import), not yet registeredS/N 42.AC038 N213WJDiamond N213wj Inc · Coral Gables, FLS/N 42.AC053 N215BNMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 42.AC055 N226DSDelta State University · Cleveland, MSBuilt 2011 · S/N 42.AC137 N228USAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 42.347 N236TSFisher Curtis R · Mankato, MNBuilt 2006 · S/N 42.AC022 N237TT42.Ac037 Inc Trustee · Wilmington, DES/N 42.AC037 N238USMeow Meow LLC · Seattle, WABuilt 2008 · S/N 42.AC128 N240TSUtah State University · Logan, UTBuilt 2005 · S/N 42.072 N242DPFlying High Again LLC · Mount Juliet, TNBuilt 2006 · S/N 42.AC032 N243TSJoerithan & Mp Aviation LLC · Whittier, CABuilt 2007 · S/N 42.AC043 N265CCInternational Air Services Inc Trustee · Carson City, NVS/N 42.AC102 N27SJ0x1b LLC · Brooklyn, NYBuilt 2006 · S/N 42.AC014 N316MZBecerra George C · Northridge, CABuilt 2007 · S/N 42.AC054 N327TSTransport Services LLC · Little Rock, ARBuilt 2006 · S/N 42.AC027 N328TSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2006 · S/N 42.AC028 N350TSUtah State University · Logan, UTBuilt 2005 · S/N 42.061 N35ALTriple M Aviation Inc Trustee · Wilmington, DEBuilt 2006 · S/N 42.147 N361GSGulf States Aircraft Sales LLC · Crossville, TNBuilt 2005 · S/N 42.101 N368TSRegistered aircraftBuilt 2008 · S/N 42.AC124 N37VKHighsky Aero Inc · Arlington, TXBuilt 2005 · S/N 42.056 N383GSGulf States Aircraft Sales LLC · Crossville, TNS/N 42.103 N384GSMabav LLC · Mooresville, NCBuilt 2006 · S/N 42.104 N388DSDelta State University · Cleveland, MSBuilt 2011 · S/N 42.AC139 N408SATake Flight Aviation LLC · Montgomery, NYBuilt 2007 · S/N 42.AC047 N415TSBeta Fleet LLC · South Burlington, VTBuilt 2006 · S/N 42.AC015 N417TSNymoon LLC · San Juan Capo, CABuilt 2006 · S/N 42.AC017 N4197DAir Shares LLC · Casper, WYBuilt 2007 · S/N 42.AC086 N422GLSummit Aviation Inc · Belgrade, MTBuilt 2007 · S/N 42.AC050 N424AMSkywarrior Flight Training LLC · Pensacola, FLBuilt 2006 · S/N 42.AC024 N424RPFlight Stars Az LLC · Mesa, AZBuilt 2007 · S/N 42.AC039 N429TPSkywest Leasing Inc · St George, UTBuilt 2005 · S/N 42.090 N42TBest Diamond 2 LLC · N Canton, OHBuilt 2007 · S/N 42.AC084 N42YJSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 42.135 N430PSMiller Air LLC · Portland, ORBuilt 2006 · S/N 42.066

Back to Diamond Aircraft Ind DA 42