Registered aircraft · 2,382

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:2013-22-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-22-21') 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:2013-22-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-22-21')
  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:2013-22-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2013-22-21')
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.

N407RMGarriott Robert · Austin, TXBuilt 2009 · S/N 53920 N407RRRains Ronald D · Odessa, TXBuilt 2012 · S/N 54332 N407RUIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2022 · S/N 54988 N407RVHelicopter Services Of Illinois LLC · Fisher, ILBuilt 1982 · S/N 3621 N407RWSacremento Executive Helicopters Inc · Acampo, CABuilt 2012 · S/N 54355 N407RXBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 54402 N407SAAlabama Law Enforcement Agency · Montgomery, ALBuilt 2000 · S/N 53449 N407SDCounty Of Onondaga · Syracuse, NYBuilt 1999 · S/N 53330 N407SETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 54386 N407SFN390sf LLC · Chandler, AZBuilt 2006 · S/N 53737 N407SGSlg Utah LLC · Toquerville, UTFirst renewal noticeBuilt 2015 · S/N 54655 N407SHStanislaus County · Modesto, CABuilt 2014 · S/N 54501 N407SJSan Juan Aviation LLC · Wilmington, DEBuilt 2004 · S/N 53608 N407SKWest States Leasing Inc · Medford, ORBuilt 1997 · S/N 53174 N407SLIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2021 · S/N 54985 N407SMMed-Trans Corp · Denton, TXBuilt 1998 · S/N 53289 N407SRRugged Flightworks LLC · Big Piney, WYBuilt 2001 · S/N 53495 N407SSState Of Indiana · Indianapolis, INBuilt 2011 · S/N 54303 N407TDElkhorn Aviation Inc · Baker City, ORBuilt 2007 · S/N 53764 N407TFTag Aviation LLC · Casper, WYBuilt 2005 · S/N 53644 N407THIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2003 · S/N 53558 N407TJAdair Jay · Dallas, TXBuilt 2024 · S/N 56422 N407TKIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2015 · S/N 54662 N407TVBlack Wolf Aviation LLC · Carencro, LAS/N 54812 N407TXAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 53892 N407USCrosswind Leasing LLC · Prescott, AZBuilt 1996 · S/N 53057 N407UTMed Trans Corp · Denton, TXBuilt 1996 · S/N 53036 N407VCBell Textron Inc · Fort Worth, TXBuilt 2018 · S/N 54806 N407VSKalispell Regional Medical Center · Kalispell, MTBuilt 2016 · S/N 54667 N407VVFlagstaff Medical Center Inc · Flagstaff, AZBuilt 2001 · S/N 53476 N407WAMed-Trans Corp · Denton, TXBuilt 1997 · S/N 53222 N407WDBrask T-4 Equipment LLC · Gallatin Gateway, MTBuilt 2019 · S/N 54851 N407WFBell 407 LLC · Bend, ORBuilt 2012 · S/N 54337 N407WHScouts Rest Ranch LLC · Darby, MTBuilt 2001 · S/N 53503 N407WTSeaguard Aviation LLC · Kalispell, MTBuilt 2024 · S/N 56420 N407XLExecutive Transport Group Inc · Las Vegas, NVS/N 53658 N407YCTvpx Ars Inc Trustee · North Salt Lake, UTS/N 54994 N407ZMIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2009 · S/N 53972 N4088YDumont Associates · Morris Plains, NJBuilt 1990 · S/N 4088 N408AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52408 N408APA & P Helicopters Inc · Richvale, CABuilt 1997 · S/N 53197 N408CCCounty Of Contra Costa · Martinez, CABuilt 2014 · S/N 54542 N408GAFlagstaff Medical Center Inc · Flagstaff, AZBuilt 1999 · S/N 53392 N408GGHfs Heli III LLC · New York, NYBuilt 2014 · S/N 54558 N408GMBostick Bowers Padgett Ltd · Jackson, GABuilt 2011 · S/N 54307 N408LFLife Flight Network LLC · Aurora, ORBuilt 2021 · S/N 54978 N408LLAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 53483 N408LMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54620 N408LNAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54433 N408MRAspen Ag Helicopters Inc · Oxnard, CABuilt 1978 · S/N 2397

Back to AD 2013-22-21