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.

N441PHPhi Aviation LLC · Lafayette, LABuilt 2011 · S/N 54081 N442PHPhi Aviation LLC · Lafayette, LABuilt 2011 · S/N 54089 N443BHBell Textron Inc · Fort Worth, TXS/N 54515 N443LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56354 N443PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 54090 N445LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56355 N445PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 54096 N445SLAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 53445 N447BFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 54447 N447GHGuardian Helicopters Inc · Fillmore, CABuilt 1997 · S/N 53213 N447LXSafe Aviation Leasing LLC · Lakeland, FLBuilt 2025 · S/N 56447 N448LFLife Flight Network LLC · Aurora, ORS/N 56359 N448PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 54111 N449LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56360 N449PPhi Health LLC · Tempe, AZBuilt 1997 · S/N 53209 N449PHPhi Health LLC · Tempe, AZBuilt 2012 · S/N 54117 N44APBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 54316 N44HCRecon Holdings LLC · Union, MIBuilt 1997 · S/N 53164 N44HXHelicopter Express LLC · Chamblee, GABuilt 1997 · S/N 53125 N450AMAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54435 N450LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56352 N450PHPhi Health LLC · Tempe, AZBuilt 2012 · S/N 54125 N451LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 56384 N452LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56380 N452PPhi Health LLC · Tempe, AZBuilt 2003 · S/N 53568 N452PHPhi Aviation LLC · Lafayette, LABuilt 2000 · S/N 53457 N453LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56382 N453PHPhi Health LLC · Tempe, AZBuilt 1998 · S/N 53266 N453RPhi Health LLC · Tempe, AZBuilt 2003 · S/N 53572 N454NCStraight Up Leasing Inc · Medford, ORBuilt 1999 · S/N 53382 N454PHPhi Aviation LLC · Lafayette, LABuilt 2000 · S/N 53435 N455LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56418 N455NCStraight Up Leasing Inc · Medford, ORBuilt 2009 · S/N 53941 N455PDCharlotte Mecklenburg Police Department · Charlotte, NCBuilt 2021 · S/N 54926 N456KBPurdy Ranch LLC · Buffalo, WYBuilt 1997 · S/N 53133 N456LFLife Flight Network LLC · Aurora, ORBuilt 2024 · S/N 56416 N457LFLife Flight Network LLC · Aurora, ORBuilt 2015 · S/N 54592 N457MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 53974 N457PHPhi Aviation LLC · Lafayette, LABuilt 1997 · S/N 53121 N458AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54551 N458ASWest States Leasing Inc · Medford, ORBuilt 2005 · S/N 53634 N458LFLife Flight Network LLC · Aurora, ORBuilt 2025 · S/N 56468 N459AMAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 54392 N45TVRedding Air Services Inc · Redding, CABuilt 1998 · S/N 53295 N460WMSouth Florida Water Mgmt District · West Palm Beach, FLBuilt 2025 · S/N 56437 N462LFLife Flight Network LLC · Aurora, ORBuilt 2025 · S/N 56460 N462PPhi Health LLC · Tempe, AZBuilt 2014 · S/N 54164 N463LFLife Flight Network LLC · Aurora, ORBuilt 2025 · S/N 56464 N464ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 53529 N464LFBell Textron Inc · Fort Worth, TXS/N 56503

Back to AD 2001-01-52 R1