OpenAirDocs.org
AD 2000-11-51

Registered aircraft · 10,470

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

N1001VLawson Justin Chadwick · Watkinsville, GABuilt 1976 · S/N R1722074N1003JTownsley Doyle · Saucier, MSBuilt 1972 · S/N 10N1004JTroxell Timothy W · Roy, WABuilt 1972 · S/N 16N1004VSalt Aerial Aviation LLC · Hamel, MNBuilt 1976 · S/N R1722075N1005UHapka 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-7570182N100AWDe 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 17252056N10162Crespi 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-8233066N101NSNoyes Gerold W · Northfield Falls, VTBuilt 2005 · S/N 1588N101UKInternational 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-1215N102BMeyjes 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 2844081N102WLBoyd Stanley E · Placitas, NMBuilt 1987 · S/N 59N1031RKeller Paul M · Sanford, NCBuilt 1989 · S/N 25-1216N1032VMatlock Jimmy R · Granbury, TXBuilt 1976 · S/N R1722088N103ALJordan John S · Sullivan, MOBuilt 1977 · S/N 0599N103GSDuce Phillip N · Kotzebue, AKBuilt 1975 · S/N 6079CN1040VWilliamson Peter D · Houston, TXBuilt 1976 · S/N R1722090N1041GN1041g LLC · Charlotte, NCBuilt 1981 · S/N 25-0567N1047AHolt Sheet Metal Inc · Durango, COBuilt 1981 · S/N 25-0571N1047QTaras Brock DBA · Cedaredge, COBuilt 1977 · S/N 28R-7703049N1049DChihuahua Airport Partners Lp · Plano, TXBuilt 1975 · S/N 0015N104DBPryce Gerald · Independence, ORBuilt 1974 · S/N MC-309
Back to AD 2000-11-51