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.

N802DSBay County Florida · Panama City, FLBuilt 2007 · S/N 53797 N803DSPasco Sheriffs Office · New Port Richey, FLBuilt 2008 · S/N 53880 N807PHWhirl'D Helicopters Inc · Sevierville, TNBuilt 2005 · S/N 53656 N808MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 54559 N808PHWhirl'D Helicopters Inc · Sevierville, TNBuilt 1997 · S/N 53101 N809PHK&S Helicopters Inc · Kailua Kona, HIBuilt 2001 · S/N 53506 N820SFN390sf LLC · Chandler, AZBuilt 1998 · S/N 53279 N829DPRotorcraft Support Inc · Fillmore, CABuilt 2012 · S/N 54113 N82APGm Leasing Company LLC · Broussard, LABuilt 2007 · S/N 53759 N82MMWestwind Helicopters Inc · Santa Fe, TXBuilt 1996 · S/N 53058 N834SFN179sf LLC · Chandler, AZBuilt 2002 · S/N 53542 N835SFN179sf LLC · Chandler, AZBuilt 2002 · S/N 53543 N84BLHelicopters Inc · Wilmington, DEBuilt 1998 · S/N 53291 N851HCGm Leasing Co LLC · Broussard, LABuilt 1997 · S/N 53179 N852LNAir Methods LLC · Greenwood Village, COBuilt 2021 · S/N 54970 N853JLBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 54351 N854HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 2009 · S/N 53976 N859MPPhoenix Coal Holdings LLC · Lexington, KYBuilt 2024 · S/N 56388 N860Helicopter 2019 LLC · Chesterfield, MOBuilt 2022 · S/N 56323 N8603Rtl Aviation LLC · Giddings, TXBuilt 2019 · S/N 54844 N861MTLindsey Aviation Services · Haslet, TXBuilt 2006 · S/N 53693 N862YBGm Leasing Company LLC · Broussard, LABuilt 2019 · S/N 54837 N864HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1996 · S/N 53017 N870AEAir Evac Ems Inc · O Fallon, MOBuilt 2025 · S/N 56443 N871AEAir Evac Ems Inc · O Fallon, MOBuilt 2025 · S/N 56451 N871STPennsylvania State Police · Hershey, PABuilt 2013 · S/N 54451 N872STPennsylvania State Police · Hershey, PABuilt 2014 · S/N 54475 N873STPennsylvania State Police · Hershey, PABuilt 2014 · S/N 54500 N874STPennsylvania State Police · Hershey, PABuilt 2014 · S/N 54494 N875STPennsylvania State Police · Hershey, PABuilt 2013 · S/N 54449 N876ACIntersouth Inc · Santo DomingoS/N 53492 N876GJBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 53820 N876STPennsylvania State Police · Hershey, PABuilt 2013 · S/N 54450 N877STArizona Helicopter Services LLC · Prescott, AZBuilt 1998 · S/N 53316 N87APGm Leasing Company LLC · Broussard, LABuilt 2004 · S/N 53624 N888DJD M Farms Of Rose Hill LLC · Wallace, NCBuilt 2000 · S/N 53408 N888PZCoastal Air LLC · Helena, MTBuilt 2008 · S/N 53898 N889MGM G 2010 LLC · Saint Petersburg, FLBuilt 2010 · S/N 54020 N889MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 54630 N88EGAviation Echo LLC · Monson, MABuilt 2025 · S/N 56427 N88VRBlue Copters LLC · Saint Petersburg, FLS/N 54902 N88ZAN88za LLC · New York, NYBuilt 2019 · S/N 54826 N894HHillcrest Aircraft Co Inc · Lewiston, IDBuilt 2012 · S/N 54383 N896KKCg Leasing LLC · Mobile, ALBuilt 2021 · S/N 54928 N897KVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 54022 N897MTTextron Financial Corp · Wichita, KSBuilt 2023 · S/N 56385 N901NMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54649 N903GAMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 54459 N903MHMansfield Heliflight Inc · Milton, VTS/N 53274 N905MFMaine Department Of Conservation · Old Town, MEBuilt 2007 · S/N 53769

Back to AD 2001-01-52 R1