AD 81-13-10 R1

Registered aircraft · 4,001

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

N741DJBruce David Alan · Jupiter, FLBuilt 1979 · S/N R1723084N741PDRocky Mountain Aviation Service LLC · Dolores, COBuilt 2002 · S/N 1179N742ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701646N742PDMers Timothy W · Haughton, LABuilt 2002 · S/N 1187N743ASA2g International LLC · San Juan Capo, CABuilt 1975 · S/N 33701647N744ACBemo LLC · Rogers, ARS/N 1041N745ASA2g International LLC · San Juan Capo, CABuilt 1977 · S/N 33701817N745MAStrategic Health Inc · Sandy, UTS/N 3449245N746ASA2g International LLC · San Juan Capo, CABuilt 1978 · S/N 33701850N747AYYoder Construction Inc · Treynor, IABuilt 2002 · S/N 1257N747FNInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 33701895N747JGGray James W · Broomfield, COBuilt 2008 · S/N 81612N747MRParkset Air Inc · Jupiter, FLS/N 25-1212N747RCConti Richard T · Orinda, CABuilt 1978 · S/N 34-7970068N749LWLease One LLC · Lafayette, INBuilt 1977 · S/N 347770416N74BLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2005 · S/N 1484N74JHAuermann John E · New Smyrna Beach, FLBuilt 1967 · S/N 337-0740N74LCommunity And Faith Initiatives · Phoenix, AZBuilt 1977 · S/N 33701814N74SESoutheast Wood Inc · Montgomery, ALBuilt 1979 · S/N R1723104N74WTOrriserv LLC · Prior Lake, MNBuilt 1981 · S/N 34-8133253N74YWBresette Matt T · Gretna, NEBuilt 1974 · S/N 6044CN750GCSquid 10 LLC · Gulfport, FLBuilt 2023 · S/N 750SD-11463N75120Kratzer Edgar · New Port Richey, FLBuilt 1976 · S/N 34-7670224N751RVCollins Albert A Jr · Baton Rouge, LABuilt 2008 · S/N 72730N75391Brennan Matthew J · Loveland, OHBuilt 1976 · S/N 34-7670246N753CZWalsh Kevin R Trustee · Alameda, CABuilt 2016 · S/N 413-689N7543VN7543v LLC · Moore Haven, FLS/N R1722309N755FMSwenson Karine M · Santa Fe, NMBuilt 1998 · S/N 25-2026N755MMDewberry Danny · Olivet, MIBuilt 1976 · S/N 6160CN757GVButterfield Tyler T · Wisconsin Dells, WIS/N 843-320-685N7588SPeraro Thomas A · Brighton, COBuilt 1979 · S/N R1723281N758AASager Joseph M · Milford, PABuilt 1978 · S/N R1722931N758ABBaerwolf Roy · Lake Havasu City, AZBuilt 1978 · S/N R1722938N758AFSims Hollow M · Lithonia, GABuilt 1978 · S/N R1722936N758AJHolman David · Bishop, CABuilt 1978 · S/N R1722939N758AKFirst Flight LLC · Titusville, FLBuilt 1978 · S/N R1722940N758ALPayne Austin · Weslaco, TXBuilt 1978 · S/N R1722941N758AMZeid Aviation LLC · Houston, TXBuilt 1978 · S/N R1722942N758APHawthorne Corporation · Richmond, VABuilt 1978 · S/N R1722944N758ARValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N R1722946N758ASRff Aviation LLC · Mount Clemens, MIBuilt 2000 · S/N 3449187N758BAFlying Aces Aviation LLC · Seminole, TXBuilt 1978 · S/N R1722954N758BDBoggs Richard D · Monroe, WABuilt 1979 · S/N R1722957N758BHBlankenship Richard A · Stillwater, MNBuilt 1978 · S/N R1722961N758BKEros Aviation Inc Trustee · Wilmington, DEBuilt 1978 · S/N R1722963N758BQMccrink Joseph J · Borrego Springs, CABuilt 1978 · S/N R1722968N758BTMikula Julie A · Half Moon Bay, CAFirst renewal noticeBuilt 1978 · S/N R1722971N758BVPhilippi Joseph E · Judith Gap, MTS/N R1722973N758BYOdom Bobby R · Berry, ALBuilt 1978 · S/N R1722976N758CBRegistration Pending · Merced, CARegistration pendingBuilt 1978 · S/N R1722979
Back to AD 81-13-10 R1