Registered aircraft · 99

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:2012-12-20') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-12-20') 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:2012-12-20')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-12-20')
  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:2012-12-20')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-12-20')
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 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 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 N327VAAir Wolfpack LLC · Grand Rapids, MIBuilt 2007 · S/N 760695 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 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 N39HFHeliflite Shares LLC · Kearny, NJBuilt 2011 · S/N 760808 N401MFDare County · Manteo, NCBuilt 2015 · S/N 20024 N40WHGm Leasing Co LLC · Broussard, LABuilt 2009 · S/N 760756 N44DSDs Air II LLC · Carrollton, VABuilt 2003 · S/N 6615 N4514RArrow Aviation Company LLC · Broussard, LAS/N 760669 N454WHGm Leasing Company LLC · Broussard, LABuilt 2010 · S/N 760802 N498AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3687 N547WMBristow LLC · Lake Charles, LABuilt 2008 · S/N 760722 N585AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3736 N590AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3733 N614JCKnight Helo LLC · Wilmington, DES/N 760694

Back to AD 2012-12-20