Skip to content

Registered aircraft · 772

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2014-19-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-19-05') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2014-19-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-19-05')
  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, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2014-19-05')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2014-19-05')
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.

N100GNFertitta Entertainment Holdings LLC · Houston, TXBuilt 2009 · S/N 6847 N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039 N103MTMed Trans Corp · Denton, TXBuilt 2009 · S/N 9286 N104LNPathfinder Leasing LLC · Anchorage, AKBuilt 2006 · S/N 4094 N105NKMed-Trans Corp · Denton, TXBuilt 2020 · S/N 9860 N108TABristow LLC · Lake Charles, LABuilt 1998 · S/N 3080 N109LNAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3995 N110SLAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9302 N111LNC Lou Leasing LLC · Mankato, MNBuilt 1984 · S/N 1602 N112AHUS Army · Redstone Arsenal, ALBuilt 2014 · S/N 9684 N113AHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 9858 N114MXAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1984 · S/N 1747 N117TVU S Helicopters Inc · Marshville, NCBuilt 2012 · S/N 7464 N118LNAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 4214 N118MBMountain Air Helicopters Inc · Dover, DEBuilt 2002 · S/N 3535 N11QANevada Helicopter Leasing LLC · Greenwoodvillage, COBuilt 2004 · S/N 3887 N11QCNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2001 · S/N 3358 N11QDMansfield Heliflight Inc · Milton, VTBuilt 2001 · S/N 3363 N11QENevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2001 · S/N 3381 N11QFNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3482 N11QHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3561 N11QJNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4528 N11QKNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3639 N11QLNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3738 N11QMNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3751 N11QNNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3758 N11QPNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2009 · S/N 4715 N11QRNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2005 · S/N 3992 N11QUNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2009 · S/N 4758 N11QWNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2010 · S/N 4929 N11QXNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2011 · S/N 7198 N11QYNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2011 · S/N 7229 N11QZNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4663 N1231ATiny Bubbles Aviation Inc · Pacoima, CABuilt 2003 · S/N 3682 N124LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 4130 N124TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4405 N125HDUS Helicopters Inc · Marshville, NCBuilt 2014 · S/N 7899 N125SCStandard Aero (Alliance) Inc · Maryville, TNBuilt 2005 · S/N 3904 N126PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 7039 N127PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 7180 N12FQN12fq LLC · Helena, MTBuilt 2003 · S/N 3726 N12NNAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2008 · S/N 4579 N12YJTiny Bubbles Aviation Inc · Pacoima, CABuilt 2008 · S/N 4443 N1308Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 760667 N130BUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7132 N130CLOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7499 N130CRRomana Aircraft Inc · High Point, NCBuilt 2007 · S/N 4271 N130CZOrbic Air LLC · Burbank, CABuilt 2006 · S/N 4060 N130EEBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7190 N130GCMonarch Enterprises Inc · Kirkland, WABuilt 2002 · S/N 3562

Back to AD 2014-19-05