Registered aircraft · 216

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:2021-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-10-21') 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:2021-10-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-10-21')
  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:2021-10-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2021-10-21')
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.

N611SJAspirus Wausau Hospital Inc DBA · Wausau, WIBuilt 2009 · S/N 9303 N618GLGundersen Lutheran Medical Center Inc · La Crosse, WIBuilt 2016 · S/N 9760 N619GESan Diego Gas & Electric Co · San Diego, CABuilt 2017 · S/N 20156 N61UPTrustees Of The University Of Pennsylvania · Philadelphia, PABuilt 2012 · S/N 9556 N624ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2023 · S/N 9883 N633MBCenterline Holdings Inc · Camden, DEBuilt 1986 · S/N S-750 N635TJAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9635 N648BHFlight For Life Inc · Waukesha, WIBuilt 2021 · S/N 9869 N65DACenter For Vertical Studies LLC · Sheridan, WYBuilt 1991 · S/N S-854 N676LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2007 · S/N 9115 N695HSMocha LLC · Tucson, AZBuilt 2016 · S/N 20047 N702LFLonian Raven LLC · Wilmington, DEBuilt 2018 · S/N 20210 N7062XPatriot Aviation Inc · Greenville, DES/N S-793 N745TXMother Frances Hospital Regional Health Care Ctr · Tempe, AZBuilt 2009 · S/N 9295 N74GHGuardian Helicopters Inc · Fillmore, CABuilt 1985 · S/N 7069 N759BHAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 9397 N766MEAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 9066 N770WSMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 9607 N779LFAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 9103 N787RCRegistered aircraftBuilt 1987 · S/N 2012 N78NCAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 9185 N8118YSanborn Richard E Trustee · Bethlehem, NHS/N 2017 N814LVAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 9137 N816ECPitt County Memorial Hospital · Greenville, NCBuilt 2015 · S/N 9685 N8199JPeace And Freedom Helicopters LLC · Wilmington, DES/N S-826 N824EHMetro Aviation Inc · Shreveport, LABuilt 2024 · S/N 9884 N843LFLife Flight Network LLC · Aurora, ORBuilt 2018 · S/N 20219 N84UCUc Health LLC · Cincinnati, OHBuilt 2022 · S/N 9873 N850UWMetro Aviation Inc · Shreveport, LABuilt 2019 · S/N 9837 N854ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2010 · S/N 9327 N874BUMetro Aviation Inc · Shreveport, LABuilt 2022 · S/N 9874 N87MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2013 · S/N 9603 N893AUMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9862 N8KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2020 · S/N 20353 N903SHSanford North · Sioux Falls, SDBuilt 2012 · S/N 9432 N906GLGundersen Lutheran Medical Center Inc · La Crosse, WIS/N 9089 N906SHSanford North · Sioux Falls, SDBuilt 2011 · S/N 9479 N908SHSanford North · Sioux Falls, SDBuilt 2011 · S/N 9482 N909SHSanford Health · Sioux Falls, SDBuilt 2010 · S/N 9359 N910NHWilmington Trust Co Trustee · Wilmington, DEBuilt 2006 · S/N 9084 N911AKMse Air Group Inc · Ciales, PRS/N S-63 N911ANAlaska Tactical Aviation LLC · Palmer, AKBuilt 1974 · S/N S-156 N911BHAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 9545 N911MKAvera Mckennan · Sioux Falls, SDBuilt 2008 · S/N 9218 N911TBCook Children'S Health Enterprises · Fort Worth, TXBuilt 2009 · S/N 9281 N911TGFlorida Health Sciences Center Inc DBA · Tampa, FLBuilt 2020 · S/N 9855 N911UWMetro Aviation Inc · Shreveport, LABuilt 2021 · S/N 9864 N911XETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1993 · S/N 7505 N912CCAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 9595 N914TGMetro Aviation Inc · Shreveport, LABuilt 1993 · S/N 7506

Back to AD 2021-10-21