Registered aircraft · 563

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

N334AEAir Evac Ems Inc · O Fallon, MOBuilt 1989 · S/N 51326 N336AEAir Evac Ems Inc · O Fallon, MOBuilt 2012 · S/N 52436 N337AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45383 N338AEGm Leasing Co LLC · Broussard, LABuilt 1994 · S/N 52087 N33PPUnited States Department Of Interior · Boise, IDBuilt 1983 · S/N 51051 N33RSFlying H Limited LLC · Mesa, AZBuilt 1992 · S/N 51568 N343ALBtak LLC · New Baden, ILBuilt 1990 · S/N 51372 N346BFState Of Washington · Olympia, WABuilt 2007 · S/N 52346 N347MJam Zoom Yayos LLC · Manheim, PABuilt 1981 · S/N EA-253 N34RMCrm Holdings LLC · Missoula, MTBuilt 2006 · S/N 52333 N35017Md Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0349FF N35019Usda Aphis Ws Atoc · Cedar City, UTBuilt 2024 · S/N 0348FF N3501DMd Helicopters LLC · Mesa, AZBuilt 2026 · S/N 0356FF N3501NMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0339FF N3501VMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0353FF N3501ZMd Helicopters LLC · Mesa, AZBuilt 2024 · S/N 0351FF N3502PMccarty David M · Baker City, ORBuilt 2023 · S/N 0346FF N351RLOas2 LLC · Orlando, FLBuilt 1991 · S/N 51431 N352TCHillsborough County Board Of County Commissioners · Tampa, FLS/N 52390 N355AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52425 N357SPLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1996 · S/N 52161 N35KHBlackbell 22 LLC · Wilmington, DEBuilt 2024 · S/N 0355FF N35NRCentral States Helicopters Inc · Wood River, NEBuilt 1995 · S/N 52137 N361ALBillings Flying Service LLC · Billings, MTBuilt 1987 · S/N 51212 N361DT925dt LLC · Picayune, MSBuilt 1994 · S/N 52080 N361SHLima Whiskey LLC · Missoula, MTBuilt 1989 · S/N 0058FF N362ALMarks Lloyd · Lafayette, LABuilt 1991 · S/N 51471 N367PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0344FF N369FFBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 0709FF N369TVTennessee Valley Authority · Muscle Shoals, ALBuilt 2017 · S/N 0269FF N36FGCalifornia Department Of Fish & Wildlife · Sacramento, CABuilt 2020 · S/N 0322FF N370DPDodson International Parts Inc · Rantoul, KSBuilt 1992 · S/N 51569 N371PDCity Of Atlanta · Atlanta, GABuilt 2023 · S/N 0345FF N3777MRotor Co · New Braunfels, TXBuilt 1991 · S/N 51485 N377LFHelicopter Parts International Inc · Minden, NVBuilt 1989 · S/N 51281 N378JCLongranger IV LLC · Missoula, MTBuilt 2013 · S/N 52448 N383SHAspen Helicopters Inc · Oxnard, CABuilt 1983 · S/N 51073 N385RLSan Juan Aviation LLC · Wilmington, DEBuilt 2008 · S/N 52385 N386VCCounty Of Volusia · Deland, FLBuilt 1996 · S/N 52179 N3893UMonarch Enterprises Inc · Kirkland, WAS/N 51020 N38BZHelicopters Inc · Wilmington, DEBuilt 1995 · S/N 52128 N396RLMorris Equipment LLC · Yuma, AZBuilt 1980 · S/N 45-396 N399AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 52490 N399MHBlade Leasing LLC · Homer, AKBuilt 1993 · S/N 52016 N39LRHornet LLC · Picayune, MSBuilt 1981 · S/N 45654 N3QYHelicopters Inc · Wilmington, DEBuilt 1999 · S/N 52224 N401FNNy On Air LLC · Kearny, NJBuilt 1994 · S/N 52081 N401FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2006 · S/N 52327 N40290Haddock Flying Service Inc · Salters, SCBuilt 1980 · S/N HA3081 N402AEAir Evac Ems Inc · O Fallon, MOBuilt 2009 · S/N 52393

Back to AD 84-24-54 R2