Skip to content

AD 2001-01-52 R1

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.

N662CVSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N 54374 N662RLRotocraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53203 N663RLRotorcraft Leasing Company LLC · Broussard, LABuilt 2001 · S/N 53479 N663SFN390sf LLC · Chandler, AZBuilt 2000 · S/N 53438 N664RLGm Leasing Company LLC · Broussard, LABuilt 1996 · S/N 53037 N665HFHalo Flight Inc · Corpus Christi, TXBuilt 2025 · S/N 56442 N666SLIrondequoit Acquisitions LLC · Miami, FLBuilt 2024 · S/N 56431 N668RLGm Leasing Company LLC · Broussard, LABuilt 1999 · S/N 53383 N669RLGm Leasing Company LLC · Broussard, LABuilt 2003 · S/N 53550 N670PCSan Diego County Sheriffs Department · San Diego, CABuilt 2023 · S/N 56345 N670RLGm Leasing Company LLC · Broussard, LABuilt 2000 · S/N 53413 N6712LBell Textron Inc · Fort Worth, TXS/N 54523 N671RLGm Leasing Company LLC · Broussard, LAS/N 53480 N673AMAir Methods LLC · Greenwood Village, COS/N 56487 N674RLGm Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53227 N675RLRotorcraft Leasing Company LLC · Broussard, LABuilt 1997 · S/N 53223 N676RLRotorcraft Leasing Company LLC · Broussard, LABuilt 2005 · S/N 53650 N67AJVictor Bravo LLC · Breaux Bridge, LAS/N 56318 N681FGM&D Investment Holdings LLC · Red Bluff, CABuilt 2007 · S/N 53753 N684HWilson White Aircraft Industries LLC · Lewiston, IDBuilt 1996 · S/N 53065 N686AMAir Methods LLC · Greenwood Village, COBuilt 1997 · S/N 53160 N686RHCrosswind Leasing LLC · Prescott, AZBuilt 2006 · S/N 53714 N687AMAir Methods LLC · Greenwood Village, COBuilt 2001 · S/N 53497 N693AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54625 N694AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54013 N694PAGm Leasing Company LLC · Broussard, LABuilt 2001 · S/N 53482 N696AMAir Methods LLC · Greenwood Village, COS/N 53564 N696STState Of Michigan · Lansing, MIBuilt 2011 · S/N 54068 N697AMAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 54628 N6989XArrow Aviation Company LLC · Broussard, LAS/N 53113 N69FHelicopters Inc · Cahokia, ILBuilt 1996 · S/N 53025 N69SGHarvey Gulf International Marine LLC · New Orleans, LABuilt 2008 · S/N 53827 N6HEHelicopter Express LLC · Atlanta, GAS/N 53235 N6YJHelicopters Inc · Linden, NJBuilt 1996 · S/N 53066 N7007RDiaz Mark · Madera, CABuilt 2019 · S/N 54839 N700WHRegistered aircraftBuilt 2022 · S/N 54997 N701ESSky Cycle LLC · Los Altos Hills, CABuilt 2005 · S/N 53635 N702FSFlo-Sun Aircraft Inc · West Palm Beach, FLBuilt 2025 · S/N 56470 N705MTBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 54141 N706MTBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 54465 N707AHAspen Helicopters Inc · Oxnard, CABuilt 2005 · S/N 53632 N707NARed Dragon Aviation LLC · Melbourne, FLBuilt 2001 · S/N 53468 N709MTMed-Trans Corp · Denton, TXBuilt 2015 · S/N 54585 N709WGSan Diego Co Sheriff Dept · El Cajon, CABuilt 2020 · S/N 54885 N712FSTrans Texas Helicopter Services LLC · Realitos, TXBuilt 2014 · S/N 54497 N712GAFlagstaff Medical Center Inc · Flagstaff, AZBuilt 2011 · S/N 54084 N712HPDepartment Of Highway Safety And Motor Vehicles · Tampa, FLBuilt 2012 · S/N 54361 N714SHRockland County New York · New City, NYBuilt 2025 · S/N 56480 N715AEGm Leasing Company LLC · Broussard, LABuilt 2006 · S/N 53731 N715GWGoing To Work Aviation Also LLC · Wildwood, FLBuilt 2013 · S/N 54454

Back to AD 2001-01-52 R1