Registered aircraft · 63

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-08-17') 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-08-17') 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-08-17')
    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-08-17')
  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-08-17')
  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-08-17')
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.

N12SPNew York State Police · Albany, NYBuilt 2000 · S/N 49069 N16KKS & S Aviation Services Inc · Pacoima, CAS/N 49100 N16UAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1984 · S/N 47141 N2042XBell Textron Inc · Fort Worth, TXS/N 47099 N20SPNew York State Police · Albany, NYBuilt 2000 · S/N 49070 N222EXNixon Eric J · Mentone, CABuilt 1980 · S/N 47043 N222FZCdh Enterprises LLC · Englewood, COS/N 47073 N222LBAerospace Trust Management LLC Trustee · Wilmington, DES/N 47071 N222LLKauffman Land & Development LLC · Ft Lupton, COBuilt 1981 · S/N 47060 N222XZSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 47048 N222ZXSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 47011 N223HXJonam LLC · Wilmington, DEBuilt 1984 · S/N 47511 N22ZWSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 47031 N230EFCentral American Aviation Services Inc · Las Vegas, NVBuilt 1993 · S/N 23007 N230GSSolomon Mark Trustee · Wilmington, DEBuilt 1995 · S/N 23037 N230HHeger Scott J · Laguna Niguel, CABuilt 1994 · S/N 23019 N230HSBirken Holdings LLC · Wilmington, DEBuilt 1994 · S/N 23022 N230MKJkr Distribution LLC · Santa Paula, CABuilt 1995 · S/N 23035 N230YBYb Bell Inc · Wilmington, DEBuilt 1994 · S/N 23023 N255MKPremier Aircraft Services LLC · Bakersfield, CABuilt 1996 · S/N 49007 N29KHInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 47053 N30836Cornerstone Financial Enterprises LLC · Mesquite, NVBuilt 1980 · S/N 47036 N322AW541 East Liberty LLC · Savannah, GABuilt 1987 · S/N 47151 N3307HCdh Enterprises LLC · Tualatin, ORS/N 47076 N34NRInternational Air Services Inc Trustee · Carson City, NVBuilt 1982 · S/N 47068 N34SFlying Tigers LLC · Jefferson City, MOBuilt 2002 · S/N 49092 N40DPLondonaire LLC · Wichita Falls, TXBuilt 1997 · S/N 49035 N427SPState Of New York · Albany, NYBuilt 2001 · S/N 49083 N430AGMcmahon Helicopter Services Inc · Canton, MIBuilt 1998 · S/N 49045 N430CFSan Juan Aviation LLC · Wilmington, DEBuilt 2006 · S/N 49118 N430CGSan Juan Aviation LLC · Wilmington, DES/N 49062 N430CMSan Juan Aviation LLC · Wilmington, DES/N 49090 N430DWGear Aviation LLC · Missoula, MTBuilt 2001 · S/N 49079 N430NYMcmahon Helicopter Services Inc · Canton, MIBuilt 2000 · S/N 49068 N430STHigh Performance Helicopters Corp · Crestline, CABuilt 2000 · S/N 49071 N430VPAerotrust Services Corp Trustee · Wilmington, DES/N 49005 N430VRAerotrust Services Corp · Wilmington, DES/N 49002 N430W430w LLC · Crestline, CABuilt 2001 · S/N 49086 N430WHAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2006 · S/N 49114 N431HFHeliflite Shares LLC · Newark, NJBuilt 1999 · S/N 49051 N431LLHm Aviation Holdings LLC · Fort Pierce, FLS/N 49128 N431SLMcmahon Helicopter Services Inc · Canton, MIBuilt 1997 · S/N 49023 N432HFHeliflite Shares LLC · Kearny, NJBuilt 2000 · S/N 49064 N432NYState Of New York · Albany, NYBuilt 2001 · S/N 49087 N449BAirtrust LLC - 16 - Series 16 Trustee · Sheridan, WYBuilt 1995 · S/N 23034 N4VEGreenway Avia Inc · Leesburg, FLS/N 47142 N556UHMcmahon Helicopter Services Inc · Canton, MIBuilt 2006 · S/N 49117 N557STShelby Patrick B Trustee · Dallas, TXBuilt 2002 · S/N 49091 N5RHHms Holdings LLC · Charlotte, NCBuilt 2002 · S/N 49093 N707LPN-707lp Inc · Houston, TXS/N 47072

Back to AD 2016-08-17