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.

N59PRInternational Air Services Inc Trustee · Carson City, NVBuilt 2019 · S/N 54832 N59WHGm Leasing Company LLC · Broussard, LABuilt 1998 · S/N 53261 N5NYHelicopters Inc · Wilmington, DEBuilt 2001 · S/N 53474 N600MTAtlantic Union Bank · Alpharetta, GABuilt 2022 · S/N 56315 N602SDJefferson County Sheriff'S Office · Beaumont, TXBuilt 2007 · S/N 53775 N603BSNhb603 LLC · Manchester, NHBuilt 2021 · S/N 54961 N6040YBell Textron Inc · Fort Worth, TXBuilt 1999 · S/N 53371 N605PDNassau County Police Dept · Bethpage, NYBuilt 2007 · S/N 53787 N606AHTextron Financial Corp · Wichita, KSBuilt 2022 · S/N 56329 N606MTTextron Financial Corp · Wichita, KSS/N 56339 N606WRW&L LLC · Dorton, KYBuilt 1997 · S/N 53201 N611ACStraight Up Leasing Inc · Medford, ORBuilt 2011 · S/N 54086 N611PAGm Leasing Co LLC · Broussard, LABuilt 2003 · S/N 53573 N613PAGm Leasing Co LLC · Broussard, LABuilt 2004 · S/N 53627 N616DEWestern Area Power Administration · Lakewood, COBuilt 2022 · S/N 54995 N616PAGm Leasing Co LLC · Broussard, LABuilt 2006 · S/N 53723 N617ACAspen Helicopters Inc · Oxnard, CABuilt 2003 · S/N 53570 N617CEBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 54967 N617DEUS Department Of Energy · Lakewood, COBuilt 2008 · S/N 53867 N618DEU S Department Of Energy · Lakewood, COBuilt 2007 · S/N 53798 N618DSVolusia Sheriffs Office · Deland, FLBuilt 2024 · S/N 56386 N618TSManatee County Mosquito Control District · Ellenton, FLBuilt 2004 · S/N 53618 N619DEUnited States Department Of Energy · Lakewood, COBuilt 2000 · S/N 53410 N620DEWestern Area Power Administration · Lakewood, COBuilt 2008 · S/N 53885 N622LTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N 54943 N625PAWebster Bank National Association · New Britain, CTBuilt 2013 · S/N 54390 N62774Bell Textron Inc · Fort Worth, TXBuilt 1997 · S/N 53206 N62ZA62za LLC · New York, NYBuilt 2014 · S/N 54155 N630KHBell Textron Inc · Fort Worth, TXS/N 54659 N630RBBarrington Aviation LLC · Rocky Mount, NCBuilt 2012 · S/N 54328 N631MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 54631 N63DJSortie II LLC · Charlotte, NCBuilt 2024 · S/N 56399 N63PPLawrence Equipment Inc · South El Monte, CABuilt 2011 · S/N 54052 N640MAMinuteman Aviation Inc · Missoula, MTBuilt 2002 · S/N 53522 N642AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 56465 N645AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 56467 N649ACLindsey Aviation Services · Haslett, TXBuilt 2020 · S/N 54879 N649AEAir Evac Ems Inc · O Fallon, MOBuilt 2008 · S/N 53872 N64AEAir Evac Ems Inc · O Fallon, MOBuilt 1997 · S/N 53138 N64WHWestwind Helicopters Inc · Santa Fe, TXBuilt 2005 · S/N 53659 N652AEAir Evac Ems Inc · O Fallon, MOBuilt 2000 · S/N 53412 N654AMAir Methods LLC · Greenwood Village, COS/N 56484 N654PFSale Reported · North Salt Lake, UTSale reportedBuilt 2016 · S/N 54679 N655RAMed-Trans Corp · Denton, TXBuilt 2012 · S/N 54116 N658HPDiamondback Equipment Leasing LLC · Avondale, AZBuilt 2005 · S/N 53665 N65DJHornet Aviation LLC · New York, NYBuilt 2024 · S/N 56398 N660AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 54108 N660AMAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 56483 N660RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1998 · S/N 53248 N661RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1998 · S/N 53284

Back to AD 2001-01-52 R1