Registered aircraft · 139

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:2016-03-02') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-03-02') 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:2016-03-02')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-03-02')
  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:2016-03-02')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-03-02')
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 N1308Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 760667 N130PFOrlando Helicopter Partners LLC · Orlando, FLBuilt 2009 · S/N 4760 N135TGAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0298 N145GRegistered aircraftBuilt 2015 · S/N 20044 N152AEMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 760714 N153AEPhi Health LLC · Tempe, AZBuilt 2004 · S/N 3829 N155JECjb Equipment Leasing LLC · Naples, FLBuilt 2003 · S/N 6633 N155RDCastro Be LLC · Miami, FLBuilt 2000 · S/N 6580 N155RRCas LLC · Longboat Key, FLBuilt 1996 · S/N 760464 N155TDAjd Aviation LLC · Dorado, PRS/N 6664 N155UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6934 N156UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6935 N157UMRegents Of The University Of Michigan · Ann Arbor, MIBuilt 2011 · S/N 6933 N176AMSpectrum Health Hospitals · Grand Rapids, MIBuilt 2007 · S/N 760665 N176FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2007 · S/N 760646 N176MTDr Heli Acquistion LLC · Princeton, NJBuilt 2004 · S/N 6677 N178MTTribeca Heli LLC · Princeton, NJBuilt 1998 · S/N 6527 N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846 N2119AArrow Aviation Co LLC · Broussard, LAS/N 760640 N25740Arrow Aviation Company LLC · Broussard, LAS/N 760732 N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273 N277FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2007 · S/N 760676 N278FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2008 · S/N 760750 N30EZHover Air LLC · Anchorage, AKBuilt 2011 · S/N 7285 N30RTBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 760511 N311WGPentair LLC · Palmetto, FLBuilt 1996 · S/N 760457 N323CHHelinet Aviation Services LLC · Van Nuys, CABuilt 2005 · S/N 760599 N327VAAir Wolfpack LLC · Grand Rapids, MIBuilt 2007 · S/N 760695 N328PKOnyx Aviation LLC · Needham, MABuilt 2005 · S/N 760604 N34HFHeliflite Shares LLC · Kearny, NJBuilt 2005 · S/N 760608 N350MPCity Of Memphis Police Department · Memphis, TNBuilt 2004 · S/N 3783 N351HDT Scott Dunn Construction Inc · Phoenix, ORBuilt 2001 · S/N 3508 N352RNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3664 N353PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3722 N354PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3690 N355JSMinerd Holdings LLC · Chicago, ILBuilt 2007 · S/N 760684 N357PAPathfinder Leasing LLC · Anchorage, AKBuilt 2003 · S/N 3675 N358TVTiny Bubbles Aviation Inc · Pacoima, CABuilt 2004 · S/N 3788 N35HFHeliflite Shares LLC · Kearny, NJBuilt 2008 · S/N 760746 N365JABank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 6585 N365RTIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2002 · S/N 6624 N36HFHeliflite Shares LLC · Kearny, NJBuilt 2009 · S/N 760776 N375AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20227 N376AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20239 N376WHGm Leasing Company LLC · Broussard, LABuilt 2009 · S/N 760759 N387AK387ak LLC · Anchorage, AKS/N 3730 N38HFHeliflite Shares LLC · Kearny, NJBuilt 2008 · S/N 760700 N38MDBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 6335

Back to AD 2016-03-02