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.

N224DPBlue And Gold Aviation LLC · Marietta, OHBuilt 1991 · S/N E-2599N224DRN224dr LLC · Morristown, NJBuilt 2000 · S/N EA-660N224HPNguyen Cody · Richmond, CABuilt 1965 · S/N D-7806N224SSmith Darrell E · Duncan, OKBuilt 1965 · S/N TC-892N224SHWhitney Bryan · Lake Havasu City, AZBuilt 1970 · S/N D-9152N2251QSabo John W · Spicewood, TXBuilt 1997 · S/N EA-604N2252LEaton David B Jr · Leicester, MABuilt 1977 · S/N M-1897N2253LFisher Robert C · Shepherdstown, WVBuilt 1976 · S/N MC-453N2255NMalard Darren L · Bismarck, NDBuilt 1974 · S/N D-9580N2257LShantz Lorne E · Phoenix, AZBuilt 1976 · S/N MC-457N2259LVelte Jerrid · Grand Haven, MIBuilt 1976 · S/N M-1898N225BWRegistered aircraftBuilt 1961 · S/N DH-325N225CRQualitair LLC Trustee · MichelstadtBuilt 1982 · S/N EA 317N225JWTalbot Larry · Lakewood Ranch, FLBuilt 2001 · S/N E-3418N225PSalem Aviation LLC · Winston Salem, NCBuilt 1997 · S/N EA-608N225R707 Aviation LLC · Batesville, MSBuilt 1974 · S/N TC1728N225SPGross Flying Service Inc · Larned, KSBuilt 1964 · S/N D-7488N225TWWallitner Aviation And Restoration LLC · Port Orchard, WABuilt 1959 · S/N DH-219N225VBas Part Sales LLC · Greeley, COBuilt 1966 · S/N TE-123N225XGomez Miguel W · Livermore, CABuilt 1957 · S/N D-5032N22604Tarten Air Inc · Smiths Creek, MIBuilt 1978 · S/N E-1287N2261LGaf Skyborne Aviation Ventures LLC · El Dorado Hills, CABuilt 1979 · S/N E-1535N2265LNeilsen Lorenzo I · Wilmington, NCS/N D-9939N2265TOracle Aviation LLC · Omaha, NEBuilt 1980 · S/N ME-333N2267AWilson Ronald W · Bluffton, SCBuilt 1969 · S/N D-9027N226DRomeo Gulf Rentals LLC · Spring, TXBuilt 1963 · S/N TD-542N226MASum Beech Inc · Knoxville, TNS/N CE-641N226STanis Dirk N · Rock Hill, SCBuilt 1965 · S/N TD-627N226SCJohnson Lansworth P · Jackson, WYBuilt 1984 · S/N EA-406N2270LBas Part Sales LLC · Greeley, COBuilt 1976 · S/N E-922N22711Big Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-865N2271LBurchinal Skyler · Brookston, TXS/N TJ-71N2272LBaum Jeffrey · Sheridan, WYBuilt 1976 · S/N D-9944N2273LLtt Flights LLC · Clinton, MOFirst renewal noticeBuilt 1976 · S/N E-925N2275LN2275l LLC · Ball Ground, GABuilt 1976 · S/N D-9945N2276CLeading Edge Consulting LLC · Mitchell, SDBuilt 1976 · S/N CE672N2277ZMorgan Charles R · Shelbyville, INS/N 4902N227BChase 13 LLC · Wilmington, DEBuilt 1956 · S/N D-4467N227BRSchoo Michael J Trustee · Ridgway, COBuilt 1977 · S/N TK-31N227BYAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1970 · S/N TC-1347N227DSL & P Air LLC · Lees Summit, MOBuilt 1957 · S/N FH-74N227MWWatson Michael Timothy · Granbury, TXBuilt 1974 · S/N D-9682N227QHanke Peter W · Chimacum, WABuilt 1964 · S/N D-7523N2283LMoser Jerald L · Tucson, AZS/N D-9948N2284LUpchurch David E · Bahama, NCBuilt 1976 · S/N E-929N2285LN2285l Aviation LLC · Robbinsville, NJBuilt 1976 · S/N E-930N2286LBaty John W · Ames, IABuilt 1976 · S/N CE-675N2288LCherryhill Aviation Inc · Freetown, INS/N TJ-70N2289LOne R Aviation LLC · Newington, CTBuilt 1976 · S/N D-9949N228ABLuke Stephen J Trustee · Middleboro, MABuilt 1991 · S/N E-2655
Back to AD 99-05-13 R1 WD