Registered aircraft · 79

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-23-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:2012-23-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:2012-23-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:2012-23-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:2012-23-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:2012-23-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.

N109AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11078 N109ALEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11113 N109BMRegistration Pending · North Salt Lake, UTRegistration pendingS/N 11157 N109BTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 22055 N109CGEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2001 · S/N 11109 N109DDLitton Global LLC · Wilmington, DEBuilt 2000 · S/N 11069 N109FBCity Of Phoenix · Phoenix, AZS/N 11629 N109HNPrestige Air LLC · Aliso Viejo, CABuilt 2000 · S/N 11087 N109MHGateway Air Center Inc · Merced, CABuilt 1998 · S/N 11026 N109PPhoenix Helicopters LLC · Dover, DES/N 11035 N109SJCarmona Cristobal Pelaez · Laredo, TXS/N 11170 N109TGTwin Rotors Flying Circus LLC · Port Orange, FLBuilt 2006 · S/N 11680 N10BLLeon Helicopter One LLC · Miami, FLBuilt 2009 · S/N 22105 N122TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 11221 N126JJFci Aeronautics LLC · Marble Falls, TXBuilt 2009 · S/N 11741 N129ARAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 11125 N197JGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 2004 · S/N 11616 N238AMAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 11084 N247HYKohilo LLC · Hillsborough, CABuilt 2022 · S/N 11158 N25JJOtu Aerospace LLC · Austin, TXBuilt 2007 · S/N 22043 N272SMEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11074 N274SMEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1998 · S/N 11034 N28NMNorth Memorial Healthcare · Brooklyn Center, MNBuilt 2005 · S/N 22003 N290SFBest Aircraft Deals LLC · Salt Lake City, UTBuilt 1998 · S/N 11022 N298RN962heli LLC · Edmond, OKBuilt 2004 · S/N 11618 N2ENEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11091 N30EHHelinet Aviation Services LLC · Van Nuys, CABuilt 1999 · S/N 11029 N30GKAircraft Partner Holdings Inc Trustee · Fallbrook, CAS/N 22155 N32NGBest Aircraft Deals LLC · Salt Lake City, UTBuilt 2001 · S/N 11112 N334JTBristow LLC · Lake Charles, LABuilt 2008 · S/N 11738 N35NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2006 · S/N 22010 N365AATristate Care Flight LLC · Greenwood Village, COBuilt 2001 · S/N 11102 N418CPEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 22068 N42NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2006 · S/N 22012 N433AKHelinet Aviation Services LLC · Van Nuys, CABuilt 2011 · S/N 11797 N435AKHelinet Aviation Services LLC · Van Nuys, CABuilt 2009 · S/N 11762 N449CTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 22066 N45SHSunflower Aviation LLC · Greenleaf, KSBuilt 2007 · S/N 22046 N508CFAerotrust Services Corp Trustee · Wilmington, DEBuilt 2001 · S/N 11103 N517QAAltus Aviation Management · Las Vegas, NVBuilt 2018 · S/N 22708 N530KSBristow LLC · Lake Charles, LABuilt 2006 · S/N 11694 N567HBCj Leasing LLC Trustee · Lakeland, FLBuilt 2010 · S/N 11780 N59PDiesel Acquisitions LLC · Milpitas, CABuilt 2007 · S/N 22036 N59ZXAs 355 LLC · Gay, GABuilt 2006 · S/N 11683 N5UVPortlock Aviation LLC · Mansfield, TXS/N 11150 N613HAHa 109e LLC · Flushing, NYBuilt 2006 · S/N 11674 N621SCSouth Bay Helicopter Service Inc · Hayward, CAS/N 22078 N65CJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 11051 N68NMNorth Memorial Healthcare · Brooklyn Center, MNBuilt 2008 · S/N 22076 N69KGBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2006 · S/N 22021

Back to AD 2012-23-02