OpenAirDocs.org
AD 99-05-13 R1 WD

Registered aircraft · 13,518

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

N214RJJones Larry V · Ocala, FLBuilt 1999 · S/N E3263N214RSFlying Kw Co · Millsap, TXBuilt 1977 · S/N E-957N2150DRegistered aircraftBuilt 1953 · S/N D-3500N2151WKimm Inc · Mocksville, NCBuilt 1974 · S/N M-1531N2153ROrton Sterling · Cedar City, UTS/N EA-540N2154DBurton Nicholas D · Clinton, TNBuilt 1953 · S/N D-3504N2154WThompson Rodney D · Texarkana, ARBuilt 1974 · S/N M-1533N2155NFlight Test Affiliates LLC · Flagler Beach, FLBuilt 1981 · S/N EA-255N2156DMoles Timothy E · New Cumberland, WVS/N D-3506N2157WTreatman Chad J · Las Vegas, NVBuilt 1974 · S/N MB-680N2159LMark A Smith Airplane Sales Inc · Homosassa, FLBuilt 1976 · S/N E-902N215BPfeffer David J · Mccook, NEFirst renewal noticeBuilt 1956 · S/N D-4581N215BFWiederhoeft Dustin L · Fairmont, MNBuilt 1964 · S/N D-7665N215CHKld Air LLC · Charlotte, NCBuilt 1977 · S/N TE-1116N215MWLutz Barry · Brookshire, TXBuilt 1956 · S/N D-4797N215NCDodson International Parts Inc · Rantoul, KSBuilt 2002 · S/N E-3444N215PDube William E Jr · Prescott, AZBuilt 1992 · S/N CE-1676N215QSooter Craig A · Sedgwick, KSS/N D-7600N215RCGulf Coast Aviation LLC · New Orleans, LAS/N MA-89N215RWUnderwood Darin M · Cedar Rapids, IABuilt 1995 · S/N E-2965N215SMahoney Christopher P · Quakertown, PABuilt 1953 · S/N D-3499N215YHodgson Mark · Fox Point, WIBuilt 1967 · S/N D-8495N2161WMatz Michael D · Hanna, INBuilt 1974 · S/N M-1551N2162DLawrence Gregory A · Lexington, KYBuilt 1953 · S/N D-3509N2163LS & S Southern Group Inc · Port Orange, FLS/N E-903N2163WBetancourt Jorge · Bowling Green, OHBuilt 1974 · S/N M-1550N2164WRegistration Pending · Carson City, NVRegistration pending, pending cancellationBuilt 1974 · S/N MB-682N2165DUllrich Arnold A · Sand Springs, OKBuilt 1953 · S/N D-3512N2165WHarrison Dan H · Englewood, FLBuilt 1974 · S/N MC252N2166DAviation Services Of Tn · Sparta, TNS/N D-3513N2167WRasmussen Anthony Paul · Gilbertsville, KYBuilt 1974 · S/N MB-685N2168LRobbins Carl K · Columbia X Rd, PABuilt 1976 · S/N E-905N2168WMaine Instrument Flight Inc · Augusta, MEBuilt 1974 · S/N MB-659N216PCUnruh James L · White Rock, NMBuilt 1963 · S/N D-7153N216RHannah Ambra · Tucker, GABuilt 1978 · S/N E1341N2171WBrown Gerado S · Miramar, FLBuilt 1974 · S/N MB-688N2172LU S Aviator LLC · Eugene, ORBuilt 1976 · S/N TC-2020N2173DLimitless Horizons Sevierville LLC · Sevierville, TNS/N D-3520N2173LPritchard Timothy L · Fargo, NDBuilt 1976 · S/N CE-666N2174WGalena Sundowner LLC · Reno, NVBuilt 1974 · S/N M-1562N2178DAir Werks LLC · Fenton, MIBuilt 1953 · S/N D-3525N2178WCarrillo Salvador Arias · Lompoc, CABuilt 1974 · S/N M-1522N217AAMoore Augustus Shine · Denver, COBuilt 1959 · S/N D-6004N217ARRgv Sky LLC · Harlingen, TXBuilt 2001 · S/N E-3421N217KEpps Ernest P Jr · Atlanta, GABuilt 1965 · S/N TC-891N217LJFessenden Hart W · Port Orange, FLBuilt 2000 · S/N E-3334N217PDanford Air Inc · Wilmington, DEBuilt 1979 · S/N CE-839N217PCClearwater Consultants Inc · Starkville, MSBuilt 2000 · S/N E-3330N217PSAnderson Jeffrey A · Runaway Bay, TXBuilt 1955 · S/N D-4109N217QLasc Aviation Inc · Callaway, FLBuilt 1964 · S/N D-7680
Back to AD 99-05-13 R1 WD