Registered aircraft · 2,381

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.

N407BKTactical Ops Support LLC · Ridge, NYS/N 54850 N407BMBravo Operations LLC · Newark, DEBuilt 2017 · S/N 54714 N407BPBell Textron Inc · Fort Worth, TXBuilt 1999 · S/N 53355 N407BRBlaise Alexander Management Inc · Muncy, PABuilt 2019 · S/N 54846 N407BUTms Aircraft Leasing LLC · Shreveport, LABuilt 2013 · S/N 54444 N407BYIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2021 · S/N 54980 N407CCCounty Of Contra Costa · Martinez, CAFirst renewal noticeBuilt 1997 · S/N 53090 N407CHClassic Medical Inc · North Salt Lake, UTBuilt 1996 · S/N 53011 N407CMSacramento Executive Helicopters Inc · Acampo, CABuilt 2006 · S/N 53722 N407CNIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1998 · S/N 53314 N407CPClassic Medical Inc · North Salt Lake, UTBuilt 1997 · S/N 53095 N407CRMed-Trans Corp · Denton, TXBuilt 1998 · S/N 53254 N407CZIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2021 · S/N 54981 N407DADillon Aero Inc · Scottsdale, AZBuilt 2019 · S/N 54863 N407DBBrock Bell LLC · Beaumont, TXBuilt 2000 · S/N 53419 N407DEPamoin 407 LLC · Brooklyn, NYBuilt 2013 · S/N 54389 N407DKPatagual Leasing LLC Trustee · Healdsburg, CABuilt 2015 · S/N 54583 N407DTN407dt LLC · Missoula, MTBuilt 2004 · S/N 53625 N407DVMike Hotel Corp · Wilmington, DEBuilt 1996 · S/N 53080 N407EMountain Pacific Aviation LLC · Bellevue, WABuilt 1996 · S/N 53019 N407ESDarana Aviation Services LLC · Hamilton, OHBuilt 2019 · S/N 54877 N407FCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 1996 · S/N 53050 N407FGState Of Nevada · Reno, NVBuilt 2008 · S/N 53853 N407FHVertol Systems Company Inc · Destin, FLFirst renewal noticeS/N 53026 N407FLSarasota County Sheriffs Office · Sarasota, FLBuilt 2012 · S/N 54357 N407FMIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2021 · S/N 54930 N407GFGeorgia Forestry Commission · Macon, GABuilt 2000 · S/N 53452 N407GHRotorcraft Support Inc · Fillmore, CABuilt 1996 · S/N 53075 N407GMBell Textron Inc · Fort Worth, TXBuilt 2020 · S/N 54805 N407GPSacramento Executive Helicopters Inc · Acampo, CABuilt 2011 · S/N 54088 N407GRGrand River Dam Authority · Tulsa, OKBuilt 2022 · S/N 54979 N407GSWindsock Management LLC · Little Rock, ARBuilt 2010 · S/N 53991 N407GXBell Textron Inc · Fort Worth, TXBuilt 2012 · S/N 54300 N407HAHelo N219ha LLC · Richmond, VABuilt 1997 · S/N 53099 N407HBRedding Air Service Inc · Redding, CABuilt 1996 · S/N 53052 N407HCAir Methods LLC · Greenwood Village, COBuilt 2020 · S/N 54911 N407HDAlleghany Ridge LLC · Middletown, DEBuilt 2008 · S/N 53894 N407HFHalo-Flight Inc · Corpus Christi, TXBuilt 2021 · S/N 54947 N407HKHawkeye Helicopter LLC · Lyndon, KSBuilt 1996 · S/N 53076 N407HPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 53537 N407JHaiti Air Ambulance Service Inc · Melville, NYBuilt 2001 · S/N 53486 N407JBAerodyne LLC · Pembroke, NHBuilt 1998 · S/N 53250 N407JFJuliet Foxtrot LLC · Scott City, KSBuilt 2025 · S/N 56439 N407JHSacramento Executive Helicopters Inc · Acampo, CABuilt 2011 · S/N 54317 N407JJQuiktrip Corp · Tulsa, OKBuilt 2022 · S/N 54998 N407JMIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2006 · S/N 53732 N407JPTango Pop LLC · Wayzata, MNBuilt 2006 · S/N 53685 N407JRInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N 54549 N407JSState Of Nevada · Minden, NVBuilt 2003 · S/N 53585 N407JTSacramento Executive Helicopters Inc · Acampo, CABuilt 2008 · S/N 53828

Back to AD 2013-22-21