Skip to content

AD 2001-01-52 R1

Registered aircraft · 986

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.

N101HFAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 53463 N1028SSt Johns County Sheriffs Office · Saint Augustine, FLBuilt 2013 · S/N 54405 N102AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54721 N103JPCity Of Jacksonville Sheriffs Office · Jacksonville, FLBuilt 2021 · S/N 54946 N104AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 54733 N105AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54024 N107AETextron Financial Corp · Wichita, KSS/N 54752 N108GRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 56489 N108SCCounty Of Sonoma · Santa Rosa, CAS/N 54728 N10LESlws LLC · Missoula, MTBuilt 2003 · S/N 53556 N110DJLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56371 N111GHGuardian Helicopters Inc · Fillmore, CABuilt 2001 · S/N 53494 N113AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54027 N114WHWestwind Helicopters Inc · Santa Fe, TXBuilt 2001 · S/N 53501 N115SFRedding Air Service Inc · Redding, CABuilt 2013 · S/N 54388 N1170Gm Leasing Co LLC · Broussard, LABuilt 2001 · S/N 53478 N117PCBank Of Utah Trustee · Salt Lake City, UTS/N 54713 N118SPMinnesota State Patrol · Saint Paul, MNBuilt 2005 · S/N 53646 N119MFMercy Flights Inc · Medford, ORBuilt 2014 · S/N 54550 N119SPState Of Minnesota · Saint Paul, MNS/N 54742 N11SPState Of New York · Albany, NYBuilt 2002 · S/N 53530 N125WHWestwind Helicopters Inc · Santa Fe, TXBuilt 2000 · S/N 53411 N12CTCt Air LLC · Clovis, NMBuilt 2006 · S/N 53743 N12HXHelicopter Express LLC · Chamblee, GABuilt 2000 · S/N 53415 N135AMAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54385 N137PDPuerto Rico Police Department · San Juan, PRBuilt 2000 · S/N 53431 N138PDPuerto Rico Police Department · San Juan, PRBuilt 2004 · S/N 53630 N139PDPuerto Rico Police Dept · San Juan, PRBuilt 2004 · S/N 53631 N13FQFly Hangar 13 LLC · Mico, TXBuilt 2017 · S/N 54731 N13FV22t Aero LLC · Anchorage, AKBuilt 2016 · S/N 54672 N13FWFly Hangar 13 LLC · Mico, TXBuilt 2013 · S/N 54417 N13MXBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 54326 N140HLGm Leasing Company LLC · Broussard, LABuilt 2003 · S/N 53575 N1416Gm Leasing Company LLC · Broussard, LAS/N 53110 N141APGm Leasing Co LLC · Broussard, LABuilt 2000 · S/N 53441 N142MAMinuteman Aviation Inc · Missoula, MTBuilt 1996 · S/N 53123 N143HBank Of Utah Trustee · Salt Lake City, UTS/N 54171 N144MAMinuteman Aviation Inc · Missoula, MTBuilt 1998 · S/N 53255 N147CBJab II LLC · Mobile, ALBuilt 2023 · S/N 56367 N148AWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2008 · S/N 53879 N149PDAdministracion De Los Servicios Generales · San Juan, PRS/N 54143 N14HXHelicopter Express LLC · Chamblee, GABuilt 1997 · S/N 53184 N14ZBlack Labs LLC · Anaconda, MTS/N 54704 N150AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54046 N152AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54049 N153PAGm Leasing Company LLC · Broussard, LABuilt 2013 · S/N 54455 N158AMAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 54811 N159AMAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 54810 N15MXBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 54327 N160AMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 54038

Back to AD 2001-01-52 R1