OpenAirDocs.org
AD 2011-26-07

Registered aircraft · 13,295

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

N1000HMumm Scott A · Brodhead, WIBuilt 1948 · S/N 15AC-2N1001VLawson Justin Chadwick · Watkinsville, GABuilt 1976 · S/N R1722074N1003HLight Winds Aviation LLC · Bay City, MIBuilt 1948 · S/N 15AC-5N1003JTownsley Doyle · Saucier, MSBuilt 1972 · S/N 10N1004JTroxell Timothy W · Roy, WABuilt 1972 · S/N 16N1004VSalt Aerial Aviation LLC · Hamel, MNBuilt 1976 · S/N R1722075N1005HMaier Dennis J · Morristown, SDBuilt 1948 · S/N 15AC7N1005UHapka Michael · Winchester, INBuilt 1989 · S/N 25-1210N1006UFike Brian Arthur · Florissant, COBuilt 1993 · S/N 24-3291N1007RUts Aviation LLC · Gainesville, VAS/N 25-0052N1007XD&R LLC · Emory, TXS/N 34-7570182N1009HHardey John R · Wasilla, AKBuilt 1948 · S/N 15AC-11N100AWDe La Torre Alfonso Jr · Brownsville, TXBuilt 1956 · S/N 28479N100KN18t Ltd · Wilmington, DEBuilt 1965 · S/N 17252599N100KHLefevers Adam · Pineville, KYS/N 28529N100WAAlcorn Stanley R · Sonora, CABuilt 1964 · S/N 17251499N100WQCarolina Queen Inc · Oak Ridge, NCBuilt 1981 · S/N 28R-8131116N100YSLally Lawrence L · Mooresville, NCBuilt 1965 · S/N 17252400N100YYInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1183N101Bene Mary D · Ketchum, OKBuilt 1964 · S/N 17252056N1010HA2 Aero LLC · Ann Arbor, MIBuilt 1949 · S/N 15AC-347N1011HUlm Gabrielle Nicole · North Pole, AKBuilt 1948 · S/N 15AC-13N1013HWhite Theodore F · Willow, AKBuilt 1948 · S/N 15AC-15N10162Crespi Tony D · Meriden, CTBuilt 1981 · S/N 25-0561N10165N10165 Corp Trustee · Wilmington, DEBuilt 1981 · S/N 25-0562N10167Sterling Air LLC · La Quinta, CABuilt 1981 · S/N 25-0563N1016UBlueskys Inc · Wilmington, DEBuilt 1982 · S/N 25-0727N1016VPlowright Aviation LLC · Aldie, VAS/N R1722082N1017GAustin Byrum Andrew C · Rogers, ARBuilt 1981 · S/N 25-0547N1017JEvans Phillip R · Dinuba, CABuilt 1972 · S/N 17N1017LTop Gun Aviation Inc · Quinnesec, MIBuilt 1981 · S/N 25-0615N1017MOstroff Nathaniel S · Summerland Key, FLBuilt 1981 · S/N 25-0564N1019JPeterson George D · Key West, FLS/N 19N1019PBoondocks Solutions LLC · Tomball, TXS/N 1037N101GKCramer Keith B · Paso Robles, CABuilt 1979 · S/N 28R-7931172N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066N101MRStick The Landing Aviation LLC · Radford, VABuilt 2006 · S/N 1732N101NSNoyes Gerold W · Northfield Falls, VTBuilt 2005 · S/N 1588N101RKettunen Alan C · Ashtabula, OHBuilt 1946 · S/N 2125N101UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 250631N1023BLeguia Augusto A · Kathleen, GAS/N 28524N1025VAviation Partners LLC · Highlands Ranch, COBuilt 1976 · S/N R1722086N1026JRodriguez Luis Jr · Columbus, GABuilt 1972 · S/N 26N1026UMooneylust LLC · Springfield, MOBuilt 1989 · S/N 25-1215N1028HConnell Michael J · Decorah, IABuilt 1948 · S/N 15AC-31N102BMeyjes Gijsbert Posthumus · Cadillac, MIS/N 337-0024N102CDSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2000 · S/N 1016N102CJJordan River Aviation LLC · Madisonville, KYBuilt 2002 · S/N 1237N102EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2002 · S/N 2844081N102WBArtemis Inc · Hauppauge, NYBuilt 1968 · S/N 337M0104
Back to AD 2011-26-07