Registered aircraft · 2,381

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:2013-22-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:2013-22-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:2013-22-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:2013-22-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:2013-22-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:2013-22-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.

N33PPUnited States Department Of Interior · Boise, IDBuilt 1983 · S/N 51051 N33QPAir Metro Helicopter Inc · New City, NYBuilt 1979 · S/N 2753 N33RSFlying H Limited LLC · Mesa, AZBuilt 1992 · S/N 51568 N342AEAir Evac Ems Inc · O Fallon, MOBuilt 1997 · S/N 53226 N343ALBtak LLC · New Baden, ILBuilt 1990 · S/N 51372 N345GRAir Evac Ems Inc · O Fallon, MOBuilt 2025 · S/N 56463 N345RRChemair Helicopters Inc · Jefferson, WIBuilt 1977 · S/N 2107 N346BFState Of Washington · Olympia, WAFirst renewal noticeBuilt 2007 · S/N 52346 N346ERCibaoair Aviation Group Inc · Middletown, DEBuilt 1995 · S/N 4337 N346GRAir Evac Ems Inc · O Fallon, MOBuilt 2025 · S/N 56474 N348ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 53586 N349ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 53639 N34AETrinkle Aviation LLC · Kingsburg, CABuilt 1979 · S/N 45218 N34BMGulf Helicopters LLC · Santa Fe, TXBuilt 1998 · S/N 53310 N34CTCorporate Auto Brokers Inc DBA · Cleveland, GABuilt 2001 · S/N 4545 N34EWPlane Fun Inc Tr Trustee · Snellville, GAS/N 2108 N34NXBennett Lumber Products Inc · Princeton, IDBuilt 2019 · S/N 54842 N34RMCrm Holdings LLC · Missoula, MTBuilt 2006 · S/N 52333 N34TP307 Air Medical Transportation LLC · Clovis, NMBuilt 2015 · S/N 54575 N34VACommonwealth Of Virginia · Richmond, VABuilt 2000 · S/N 53454 N351RLOas2 LLC · Orlando, FLBuilt 1991 · S/N 51431 N3521TMbm Aviation Consultants Inc · Wilmington, DEBuilt 1979 · S/N 2703 N3523TMoreau Robert D · Granbury, TXBuilt 1979 · S/N 2637 N3528TR&B Helicopters Inc · Salinas, CABuilt 1981 · S/N 3516 N352HRJoe H Anderson Jr & Sons Inc · Old Town, FLBuilt 2016 · S/N 54677 N352MCCitrus County Mosquito Control District · Lecanto, FLBuilt 1973 · S/N 1131 N352MHMaritime Helicopters Inc · Homer, AKBuilt 1996 · S/N 53032 N352TCHillsborough County Board Of County Commissioners · Tampa, FLS/N 52390 N353HKHkb Global Supply LLC · Wilmington, DEBuilt 2012 · S/N 54353 N3546TStraight Up Leasing Inc · Medford, ORBuilt 2006 · S/N 53671 N354SPLouisiana State Police · Baton Rouge, LABuilt 2024 · S/N 56402 N355AEAir Evac Ems Inc · O Fallon, MOBuilt 2011 · S/N 52425 N355MHMaritime Helicopters Inc · Homer, AKBuilt 2008 · S/N 53851 N355SPLouisiana State Police · Baton Rouge, LABuilt 2024 · S/N 56403 N356LArizona Helicopter Services LLC · Prescott, AZS/N 51378 N356MHMaritime Helicopters Inc · Homer, AKBuilt 1999 · S/N 53372 N357AMAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 54536 N357BPIntermountain Air Inc · Colorado Springs, COS/N 56491 N357MCHillsborough County Board Of County Commissioners · Tampa, FLBuilt 1995 · S/N 4355 N357SPLouisiana Department Of Public Safety · Baton Rouge, LABuilt 1996 · S/N 52161 N358HPMoe Dubois Excavating Inc · Shelburne, VTS/N 662 N358RLTopside Aviation Inc · Brasstown, NCBuilt 1979 · S/N 2736 N35LWestwind Helicopters Inc · Santa Fe, TXBuilt 2000 · S/N 53402 N35LTDohertys Toys Second LLC · Lakeland, FLBuilt 2022 · S/N 56321 N35NRCentral States Helicopters Inc · Wood River, NEBuilt 1995 · S/N 52137 N35RPB & B Investments Inc · Yucaipa, CAS/N 1431 N361ALBillings Flying Service LLC · Billings, MTBuilt 1987 · S/N 51212 N361DT925dt LLC · Picayune, MSBuilt 1994 · S/N 52080 N361HFHalo Flight Inc · Corpus Christi, TXBuilt 2024 · S/N 56421 N362ALMarks Lloyd · Lafayette, LABuilt 1991 · S/N 51471

Back to AD 2013-22-21