Registered aircraft · 985

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

N407PPhi Health LLC · Tempe, AZBuilt 2000 · S/N 53464 N407PAMaritime Helicopters Inc · Homer, AKBuilt 2003 · S/N 53567 N407PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 54942 N407PDCharlotte Mecklenburg Polic Deptartment · Charlotte, NCS/N 53161 N407PFBell Textron Inc · Fort Worth, TXBuilt 1997 · S/N 53157 N407PGRedding Air Service Inc · Redding, CABuilt 2007 · S/N 53771 N407PJP J Helicopters Inc · Red Bluff, CABuilt 2001 · S/N 53469 N407PMHc 407 LLC · Missoula, MTBuilt 2026 · S/N 56478 N407PRWindsock Managmement LLC · Little Rock, ARBuilt 1997 · S/N 53162 N407PWIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2023 · S/N 56363 N407REastern Aviation Fuels Inc · New Bern, NCBuilt 2000 · S/N 53451 N407RATranspais Aviation LLC · Salt Lake City, UTBuilt 2013 · S/N 54396 N407RES & S Aviation Services Inc · Pacoima, CABuilt 2009 · S/N 53930 N407RFFlagstaff Medical Center · Flagstaff, AZBuilt 2009 · S/N 53919 N407RHMaritime Helicopters Inc · Homer, AKBuilt 1998 · S/N 53258 N407RJDixon John W · Asotin, WABuilt 2002 · S/N 53539 N407RLHillsboro Aviation Inc · Hillsboro, ORBuilt 2002 · S/N 53513 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 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, UTBuilt 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

Back to AD 2001-01-52 R1