Registered aircraft · 109

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:2018-16-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-16-08') 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:2018-16-08')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-16-08')
  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:2018-16-08')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-16-08')
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 N109AZWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 22223 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 N109SPDouble Or Nothing LLC · Prosper, TXBuilt 2012 · S/N 22291 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 N209JBChevron USA Inc · Picayune, MSBuilt 2024 · S/N 22454 N20ANChevron USA Inc · Picayune, MSBuilt 2024 · S/N 22453 N238AMAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 11084 N23SHIndiana Helicopters LLC · Fort Wayne, INBuilt 2012 · S/N 22285 N247HYKohilo LLC · Hillsborough, CABuilt 2022 · S/N 11158 N251HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2010 · S/N 22221 N259AZUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 22469 N25JJOtu Aerospace LLC · Austin, TXBuilt 2007 · S/N 22043 N261HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2011 · S/N 22247 N26SHIndiana Helicopters LLC · Fort Wayne, INBuilt 2016 · S/N 22360 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 N291HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2013 · S/N 22313 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 N362CRU S Bank Equipment Finance Division · Marshall, MNBuilt 2022 · S/N 22434 N365AATristate Care Flight LLC · Greenwood Village, COBuilt 2001 · S/N 11102 N385RTIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 22385 N418CPEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 22068 N42NMNorth Memorial Health Care · Brooklyn Center, MNBuilt 2006 · S/N 22012 N431HCUS Bank Na · Marshall, MNBuilt 2019 · S/N 22404 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

Back to AD 2018-16-08