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.

N523PCSacramento Executive Helicopters Inc · Acampo, CABuilt 2008 · S/N 53875 N524SPArkansas State Police · Little Rock, ARBuilt 2008 · S/N 53881 N5259NBex Inc · Wilmington, DEBuilt 1997 · S/N 53192 N527MTMed-Trans Corp · Denton, TXBuilt 2018 · S/N 54828 N528AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 56459 N528MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 54829 N531PAGm Leasing Company LLC · Broussard, LABuilt 2008 · S/N 53876 N536PDWestchester County Department Of Public Safety · Hawthorne, NYBuilt 2024 · S/N 56390 N536PWAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2015 · S/N 54577 N53AMBell Textron Inc · Fort Worth, TXS/N 56493 N53DJKeybank Na · Superior, COBuilt 2022 · S/N 56327 N53VACommonwealth Of Virginia · North Chesterfield, VABuilt 2025 · S/N 56432 N541MTTextron Financial Corp · Wichita, KSBuilt 2019 · S/N 54876 N542MTLendingclub Bank Na · Boston, MABuilt 2020 · S/N 54887 N543MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 54909 N544BTRegistered aircraftN-number assigned (import), not yet registeredS/N 56524 N546MTAtlantic Union Bank · Alpharetta, GABuilt 2022 · S/N 54991 N54AZN179sf LLC · Chandler, AZBuilt 2004 · S/N 53588 N54HKAir Methods LLC · Greenwood Village, COBuilt 2020 · S/N 54903 N552CHOrange County Sheriff'S Office · Orlando, FLBuilt 2020 · S/N 54906 N553HDHelicopters Inc · Wilmington, DEBuilt 1998 · S/N 53304 N555ASAero Leasing Inc · Medford, ORBuilt 2004 · S/N 53591 N555ZAN555za LLC · Clifton, NJBuilt 2006 · S/N 53703 N556GRRegistered aircraftN-number assigned (import), not yet registeredS/N 56566 N556NBBell Textron Inc · Fort Worth, TXS/N 54609 N557FWSilver Creek Aviation Services · Fort Worth, TXBuilt 2012 · S/N 54373 N557MTTextron Financial Corp · Wichita, KSBuilt 2024 · S/N 56409 N559MTMed-Trans Corp · Denton, TXS/N 54999 N55APTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 54718 N55FSTm Helicopter LLC · Oviedo, FLBuilt 2012 · S/N 54094 N55RTRt Oliver Investments Inc · Oklahoma City, OKS/N 53940 N560WMN390sf LLC · Chandler, AZBuilt 2006 · S/N 53706 N561BACsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2021 · S/N 54951 N561SFN390sf LLC · Chandler, AZBuilt 2000 · S/N 53456 N565DDAfricair Inc · Miami, FLS/N 56500 N567DCFalcon Aviation & Jet Sales LLC · Parrish, FLBuilt 2021 · S/N 54945 N567RJR J Corman Aviation Services LLC · Nicholasville, KYBuilt 2000 · S/N 53432 N56AZState Of Arizona Department Of Public Safety · Phoenix, AZBuilt 2004 · S/N 53616 N570WMN390sf LLC · Chandler, AZBuilt 2006 · S/N 53708 N571DABank Of Utah Trustee · Salt Lake City, UTS/N 54640 N572DABank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 54650 N575NENebraska State Patrol · Lincoln, NEBuilt 2005 · S/N 53670 N576MRegistered aircraftBuilt 2017 · S/N 54698 N579LBCollier Mosquito Control District · Naples, FLBuilt 2021 · S/N 54982 N583HBank Of Utah Trustee · Salt Lake City, UTS/N 54758 N58436Valiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 54394 N58AZState Of Arizona · Phoenix, AZBuilt 2006 · S/N 53736 N591PAGm Leasing Co LLC · Broussard, LABuilt 2013 · S/N 54456 N592PDWestchester County Dept Of Public Safety Trnspn · Hawthorne, NYBuilt 2011 · S/N 54073 N594RLGm Leasing LLC · Broussard, LABuilt 2004 · S/N 53594

Back to AD 2001-01-52 R1