Diamond Aircraft Ind DA 42 NG
Registered aircraft · 149
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 ('2990105', '2990205')
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 ('2990105', '2990205')
ORDER BY n_numberRun 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.
N101SWSkywarrior Flight Training LLC · Pensacola, FLN107NGMccarren Aviation LLC · Green Bay, WIN108NGRockhill Aerospace Inc · Molino, FLN112NGWestern United Aviation LLC · Yacolt, WAN126NGFjr Consulting Inc · Reno, NVN135DAStella Gem LLC · Belmont, CAN141DACinden LLC · Nashua, NHN142GSFort Wayne Aircraft LLC · Fort Wayne, INN142NGFive Star Marketing Inc · Raleigh, NCN147TSTreacy Jonathan T · Oxford, MEN151MABridgewater State University · New Bedford, MAN153TSAirplane Holding LLC · Huntington Station, NYN168PFJetnexa Eleven LLC · Gilbert, AZN181CWDiamond 42 N123 Magic Carpet Inc Trustee · Wilmington, DEN1836TAndromeda Air LLC · Houston, TXN190TMN190tm Inc Trustee · Wilmington, DEN1926EEmbry Riddle Aeronautical Univ Inc · Prescott, AZN19TSPremier Aircraft Sales Inc · Fort Lauderdale, FLN1PPLevel One Trauma Pllc · Sherman, TXN212SADiamond Aircraft Sales U S A Inc · London OntarioN227SKAlf Ix LLC · Chicago, ILN230PASl Aviation LLC · Lakeville, MNN233AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZN234LMRegistered aircraftN242BLTake Flight Aviation LLC · Montgomery, NYN246CFArq Aviation LLC · Wilmington, NCN257LAAa Aviation LLC · Nashville, TNN25HSSkyline Aviation Inc · San Angelo, TXN265PSMyflight Five LLC · Lake Mary, FLN26ZTHuang Zitai · Frisco, TXN272MBYankee Lima One LLC · Bolingbrook, ILN294DMMarkquart Air LLC · Chippewa Falls, WIN295RAFlight Stars LLC · Prescott, AZN296SKAlf Ix LLC · Chicago, ILN302EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN303ERDiamond Aircraft Sales U S A Inc · London OntarioN303SWSkywarrior Flight Training LLC · Pensacola, FLN304ERDiamond Aircraft Sales U S A Inc · London OntarioN304SWSkywarrior Flight Training LLC · Pensacola, FLN305EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN306EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN308EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN309EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN311EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN311LHWingsleasing LLC · Wichita, KSN312EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN313EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLN314EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN3150AOklahoma Aviation LLC · Bethany, OKN315XAJetnexa Thirteen LLC · Gilbert, AZ
Back to Diamond Aircraft Ind DA 42 NG