OpenAirDocs.org
AD 2021-23-13

Registered aircraft · 11,278

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
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-23-13')
    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-23-13')
  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.

N1002XMd Helicopters LLC · Mesa, AZS/N 0362FFN1004RMd Helicopters LLC · Mesa, AZS/N 0363FFN1004TI1 Aviation LLC · Ronkonkoma, NYBuilt 2010 · S/N 13012N1005GMd Helicopters LLC · Mesa, AZS/N 0364FFN10065Johnson Kyle · Exira, IABuilt 1949 · S/N 830N1006CMd Helicopters LLC · Mesa, AZS/N 0365FFN1006MMd Helicopters LLC · Mesa, AZS/N 0366FFN1006TMd Helicopters LLC · Mesa, AZS/N 0367FFN1007GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9164N1008HMd Helicopters LLC · Mesa, AZS/N 0369FFN100ATWestern Pacific Fisheries · Hermosa Beach, CABuilt 1980 · S/N 500718DN100EEConcho Aviation LLC · Sterling City, TXBuilt 2006 · S/N 11028N100ENRegistration Pending · Downingtown, PARegistration pending, pending cancellationS/N 816N100GNFertitta Entertainment Holdings LLC · Houston, TXBuilt 2009 · S/N 6847N100HTMitchell Brian N · Scottsdale, AZBuilt 2010 · S/N 2N100KRJjj Holdings LLC · Eugene, MOBuilt 2025 · S/N 1458N100LMHaddock Flying Service Inc · Salters, SCS/N 1583N100NJAlba Leasing Services LLC · Scottsdale, AZBuilt 1987 · S/N 3992N100VBKindlimann Charles T Jr · Trout Run, PABuilt 1966 · S/N 3552N100WGTotal Helicopters Unlimited · Stafford, VAS/N 57341N100WRBuehler Andrew · Eatonville, WABuilt 1981 · S/N 157N10175Bassett Donald J · Midland City, ALBuilt 1954 · S/N 1272N10195Deuchar Hillary · Brookings, ORS/N 562N10196Porter Kelton B · Homer, AKBuilt 1960 · S/N 340N1019VQualitair LLC Trustee · MichelstadtS/N 1353N101AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45454N101CHTri-State Vegetation Management LLC · Vevay, INS/N 1000829DN101CLBritronix Inc · Las Vegas, NVBuilt 1973 · S/N 1061N101DGSummit Helicopters Inc · Salem, VABuilt 1986 · S/N 3929N101GD101 Gd Corp · Miami, FLBuilt 2021 · S/N 14434N101HFAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 53463N101HXHelicopter Express LLC · Chamblee, GABuilt 2024 · S/N 39123N101JJStillwater Aviation LLC · Champaign, ILBuilt 2022 · S/N 57443N101MFUsda Forest Service Fepp · Trenton, NJBuilt 1957 · S/N 1953N101MZBohonis David C · North DeltaNon-citizen corporation, flight hours not reportedBuilt 1980 · S/N 5045N101SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14728N101SYRegistered aircraftBuilt 1970 · S/N 201374N101TVSky Helicopters Inc · Garland, TXBuilt 1998 · S/N 0475N101VUAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 9039N101ZWParis Air Inc · Vero Beach, FLBuilt 2007 · S/N 0276N1020GHelifun Expeditions LLC · Kalispell, MTBuilt 2016 · S/N 8250N1020QMike Rinker Aircraft LLC · Union City, TNS/N 115-0426N1020STactical Turtle LLC · Sheridan, WYBuilt 1966 · S/N 26-0467N1020TSchroth Charles D · Gustavus, AKBuilt 1966 · S/N 56-0554N1020ZBowar Gary R · Miranda, SDBuilt 1966 · S/N 66-0601N1023GContinental Title Trust LLC Trustee · Wichita, KSBuilt 1953 · S/N 51-16307N1023VPeterson Chester L · Willis, TXS/N 2021N10248Aeroxs Inc · Swainsboro, GABuilt 1977 · S/N 1502N1026YKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2005 · S/N 36391N1028SSt Johns County Sheriffs Office · Saint Augustine, FLBuilt 2013 · S/N 54405
Back to AD 2021-23-13