Skip to content

Registered aircraft · 58

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:2000-20-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-20-06') 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:2000-20-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-20-06')
  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:2000-20-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-20-06')
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 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 N122TCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 11221 N126JJFci Aeronautics LLC · Marble Falls, TXBuilt 2009 · S/N 11741 N129ALNiihau Helicopters Inc · Makaweli, HIS/N 10029 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 N272SMEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11074 N274SMEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1998 · S/N 11034 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 N32NGBest Aircraft Deals LLC · Salt Lake City, UTBuilt 2001 · S/N 11112 N334JTBristow LLC · Lake Charles, LABuilt 2008 · S/N 11738 N365AATristate Care Flight LLC · Greenwood Village, COBuilt 2001 · S/N 11102 N433AKHelinet Aviation Services LLC · Van Nuys, CABuilt 2011 · S/N 11797 N435AKHelinet Aviation Services LLC · Van Nuys, CABuilt 2009 · S/N 11762 N508CFAerotrust Services Corp Trustee · Wilmington, DEBuilt 2001 · S/N 11103 N530KSBristow LLC · Lake Charles, LABuilt 2006 · S/N 11694 N567HBCj Leasing LLC Trustee · Lakeland, FLBuilt 2010 · S/N 11780 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 N65CJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 11051 N6JEEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11095 N6VZLeonardo Helicopters US Corp · Philadelphia, PABuilt 2000 · S/N 11099 N749SDRocklyn Leasing LLC · Duluth, GABuilt 2002 · S/N 11155 N7ADEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11098 N7UCTristate Care Flight LLC · Greenwood Village, COBuilt 2000 · S/N 11088 N80NYWgb Holdings LLC · Sparta, NJS/N 11214 N820FTBristow LLC · Lake Charles, LABuilt 2007 · S/N 11701 N827KUEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11609 N85KVKhosla Ventures LLC · San Jose, CABuilt 2002 · S/N 11145 N901CMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11611 N901EMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11614 N901HCIhc Health Services Inc DBA · Salt Lake City, UTBuilt 1988 · S/N 10033 N910LBBristow LLC · Lake Charles, LABuilt 2006 · S/N 11682 N91LFInternational Defense & Aerospace Group LLC · Glen Mills, PABuilt 2002 · S/N 11509

Back to AD 2000-20-06