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.

N30HFN179sf LLC · Chandler, AZBuilt 2007 · S/N 53776 N30VACommonwealth Of Virginia · Richmond, VABuilt 2000 · S/N 53453 N311DJAutonomy Aerospace LLC · Bayamon, PRS/N 53440 N312MHMaritime Helicopters Inc · Homer, AKBuilt 2006 · S/N 53740 N312STState Of Michigan · Lansing, MIBuilt 2014 · S/N 54553 N313DPSan Diego County Sheriff Dept · El Cajon, CABuilt 2019 · S/N 54880 N314JPCity Of Jacksonville · Jacksonville, FLBuilt 2004 · S/N 53587 N314SFN179sf LLC · Chandler, AZS/N 53552 N3191Gm Leasing Co LLC · Broussard, LABuilt 1997 · S/N 53211 N319MHMaritime Helicopters Inc · Homer, AKBuilt 1997 · S/N 53153 N319MWSan Diego County Sheriff Department · El Cajon, CABuilt 2019 · S/N 54841 N325MHMaritime Helicopters Inc · Homer, AKBuilt 2002 · S/N 53544 N32DJKeybank Na Its Division Key Equipment Finance · Superior, COBuilt 2022 · S/N 56325 N330BCBell Textron Inc · Fort Worth, TXBuilt 2006 · S/N 53717 N338AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54638 N338JD22t Aero LLC · Anchorage, AKBuilt 2021 · S/N 54983 N33HFHalo-Flight Inc · Corpus Christi, TXBuilt 2015 · S/N 54567 N342AEAir Evac Ems Inc · O Fallon, MOBuilt 1997 · S/N 53226 N345GRAir Evac Ems Inc · O Fallon, MOBuilt 2025 · S/N 56463 N346GRAir Evac Ems Inc · O Fallon, MOBuilt 2025 · S/N 56474 N348ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 53586 N349ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 53639 N34BMGulf Helicopters LLC · Santa Fe, TXBuilt 1998 · S/N 53310 N34NXBennett Lumber Products Inc · Princeton, IDBuilt 2019 · S/N 54842 N34TP307 Air Medical Transportation LLC · Clovis, NMBuilt 2015 · S/N 54575 N34VACommonwealth Of Virginia · Richmond, VABuilt 2000 · S/N 53454 N352HRJoe H Anderson Jr & Sons Inc · Old Town, FLBuilt 2016 · S/N 54677 N352MHMaritime Helicopters Inc · Homer, AKBuilt 1996 · S/N 53032 N353HKHkb Global Supply LLC · Wilmington, DEBuilt 2012 · S/N 54353 N3546TStraight Up Leasing Inc · Medford, ORBuilt 2006 · S/N 53671 N354SPLouisiana State Police · Baton Rouge, LABuilt 2024 · S/N 56402 N355MHMaritime Helicopters Inc · Homer, AKBuilt 2008 · S/N 53851 N355SPLouisiana State Police · Baton Rouge, LABuilt 2024 · S/N 56403 N356MHMaritime Helicopters Inc · Homer, AKBuilt 1999 · S/N 53372 N357AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54536 N357BPIntermountain Air Inc · Colorado Springs, COS/N 56491 N35LWestwind Helicopters Inc · Santa Fe, TXBuilt 2000 · S/N 53402 N35LTDohertys Toys Second LLC · Lakeland, FLBuilt 2022 · S/N 56321 N361HFHalo Flight Inc · Corpus Christi, TXBuilt 2024 · S/N 56421 N363HBank Of Utah Trustee · Salt Lake City, UTS/N 54175 N365AEAir Evac Ems Inc · O Fallon, MOS/N 54717 N365MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54719 N366APBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 53935 N366SPNew Hampshire State Police · Concord, NHBuilt 2002 · S/N 53528 N369PAGm Leasing Co LLC · Broussard, LABuilt 1996 · S/N 53015 N36VACommonwealth Of Virginia · N Chesterfield, VABuilt 2001 · S/N 53472 N372ALAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54584 N372AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54587 N373MZBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 56378 N373RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1999 · S/N 53373

Back to AD 2001-01-52 R1