OpenAirDocs.org
AD 71-11-02

Registered aircraft · 7,046

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

N1004NStokes David A · Burton, MIBuilt 1972 · S/N 167N100NYAplustill Keith A · Los Osos, CABuilt 1985 · S/N 24-1526N100SELanger Paul Hubert · Gainesville, TXBuilt 1971 · S/N RM-1N100TCMckinney Richard P · Fayeteville, ARBuilt 1973 · S/N 28R-7335370N100UVJohn B Bateman · Draper, UTBuilt 2004 · S/N 40.405N1010YGregory Kenneth · Crowley Lake, CABuilt 1970 · S/N 28R-35800N1011JJames Robert L · East Setauket, NYBuilt 1972 · S/N 11N1012XSunbeam Air Operations LLC · Wilmington, DEBuilt 1975 · S/N 28R-7535215N1013XBtm Aero LLC · Mansfield, TXS/N 28R-7535216N1015CCrabtree Chris R · Mooresville, NCBuilt 2020 · S/N STD-FG-565N101CMKuhns Robert M · Wichita, KSBuilt 1973 · S/N MC-146N101DMClunan John S · Chocorua, NHBuilt 1975 · S/N 391N101GLAssociated Aircraft LLC · San Diego, CAS/N 0714N101JKKaras Dean · Lansing, KSS/N 28R-7335243N101JPKrouse Donald E · Weaverville, CABuilt 2002 · S/N 40.218N101LULynn University Inc · Boca Raton, FLBuilt 1999 · S/N 17280709N101MGWhatley Danny Wayne · Palmer, AKBuilt 1997 · S/N 0010N101TWMiller Colton · Mckinney, TXBuilt 1990 · S/N TMW-1N101UAReichard David Elijah · Breinigsville, PABuilt 1960 · S/N 23-1950N101VKWings Over Texas Holdings LLC · Denton, TXBuilt 1999 · S/N 172S8211N1021XO-D LLC · Kalispell, MTBuilt 1975 · S/N 28R-7535219N1022XLeggett Air LLC · Cairo, GABuilt 1975 · S/N 28R-7535220N1024U24u Aviation LLC · Wilmington, DEBuilt 1971 · S/N 34-7250004N102FVGruba Sheila M · Saint Joseph, MNBuilt 1998 · S/N 17280552N102MOk Av8r LLC · Iowa Park, TXBuilt 2002 · S/N 175N102WZVcxi Red LLC · Sheridan, WYBuilt 2019 · S/N 70737N1032SThurber Matthew Calbraith · Vancouver, WABuilt 1980 · S/N 144-HN1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222N1036JPremier Jets Inc · Hillsboro, ORS/N 36N1037JTate Andrew E · Chapel Hill, NCBuilt 1973 · S/N 37N1038JLandgraf Robert J · Sussex, WIBuilt 1973 · S/N 118N1039JN1039j LLC · Casa Grande, AZBuilt 1973 · S/N 101N1039MManly James H · Reno, NVBuilt 1998 · S/N 513N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024N103AASmith George Barker · Lexington, KYBuilt 2007 · S/N 2411N103FVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280553N103KFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1999 · S/N 172S8143N103LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280298N103RGTupelo Aeronautics Inc · Tupelo, MSBuilt 1975 · S/N MC358N1040JHefferon John W · Locust Grove, GABuilt 1973 · S/N 40N1040UAmerican Aviation Inc · Brooksville, FLS/N 34-7250025N1042UShackleford Developments Of Sc LLC · Mount Pleasant, SCBuilt 1971 · S/N 34-7250026N1042XN1042x LLC · Papillion, NEBuilt 1975 · S/N 28R-7535223N1043JLanmon Herman Jr · Hamilton, TXBuilt 1974 · S/N 127N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025N1043XAustin Security Corp · Battleboro, NCBuilt 1975 · S/N 28R-7535224N1044JNagasaka Bruce J · Weiser, IDBuilt 1973 · S/N 44N1045LBernard Robert J · Millbury, MABuilt 1974 · S/N 638N1047JFirst Flight Investments LLC · Bartow, FLBuilt 1973 · S/N 47N1048LSparrow Thomas E · Hawley, MNBuilt 1974 · S/N 641
Back to AD 71-11-02