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.

N9024VMinick Allen R · Beatrice, NEBuilt 1971 · S/N TE-837N9025QVee Tails Of Flying Cloud Inc · Excelsior, MNBuilt 1970 · S/N TC-1356N9029SKubier Martin · Yukon, OKBuilt 1965 · S/N D-7956N9029VNeighbor David H · Fairway, KSBuilt 1972 · S/N TC-1485N902ATAbet · Freeport, MEBuilt 1991 · S/N E2623N9030BShe Said Yes LLC · Verona, ILBuilt 1962 · S/N BA-641N9033FMarshall Randy M · Dallas, TXBuilt 1990 · S/N CE-1456N9033QDavid E Weissman · San Diego, CABuilt 1970 · S/N D-9208N9034SMcnurlin Thomas C · Tucson, AZBuilt 1965 · S/N D-7960N9034VVanderhoof Consulting LLC · Omaha, NEBuilt 1972 · S/N E-368N9035QBrown Vintage Airlines LLC · Mansfield, OHBuilt 1970 · S/N CE-310N9035SRick Aviation Inc · Newport News, VABuilt 1965 · S/N TC-956N9036VRobbins Ethan · North Grafton, MABuilt 1970 · S/N E-233N9038SRed Rock Flyers LLC · Flagstaff, AZBuilt 1965 · S/N TC-961N9039VCarper Paul · Conroe, TXBuilt 1973 · S/N E-391N903ATEga Three LLC · Gadsden, TNBuilt 1991 · S/N E2627N903VCrawford Carlos G · Osprey, FLBuilt 1974 · S/N E-562N9041CAlexander Stephen L · Sugar Land, TXBuilt 1977 · S/N D-10096N9041SMarzich Frank M · Rockford, ILBuilt 1965 · S/N D-7963N9041VSera Adam J · New Market, MDS/N CE-429N9042STruly Ted · Sherman, TXBuilt 1965 · S/N D-7964N9042W42w LLC · Jackson, MOBuilt 1974 · S/N E-605N9043RNogle Charles H · Champaign, ILS/N G-301N9044SAshby Peter L Sr · Cadillac, MIBuilt 1965 · S/N D-7941N9045QJohnson Steven F · Ennis, TXBuilt 1970 · S/N E-231N90460Mitchell Aircraft Components Inc · Borrego Springs, CABuilt 1958 · S/N A-937N9048QNogle And Black Aviation Inc · Champaign, ILBuilt 1970 · S/N D-9189N9048SWienke Maximillian Martin · Sheppard Afb, TXBuilt 1966 · S/N D-8035N904ADNorth South Aviation LLC · Belgrade Lakes, MEBuilt 1974 · S/N E-624N904ATBeitler Jonathan J · Camden, MEBuilt 1991 · S/N E2629N904TMax Q Aviation LLC · Cocoa Beach, FLBuilt 1974 · S/N TC-1755N90502Glover William Scott · Mt Pleasant, TXBuilt 1947 · S/N A-346N9050SPense Jeff · Jenks, OKBuilt 1965 · S/N D-8038N9053QOrville Ventures LLC · Leawood, KSBuilt 1970 · S/N D-9196N9054SWhiskey Lima Aviation LLC · Duluth, GABuilt 1978 · S/N TC-2160N90552Aeropacific Corp · Idaho Falls, IDBuilt 1948 · S/N A-420N9056SKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 1978 · S/N E-1301N90575Benschoter Cameron Paulk · Jonesboro, GAFirst renewal noticeBuilt 1948 · S/N D-1848N9057QCurrier Justin B · Rixeyville, VABuilt 1971 · S/N TC-1366N9058STeam Training Institute LLC · Atlanta, GABuilt 1978 · S/N TC-2161N905AAGraber Joel C · Collins, MSS/N TK65N905ATWagner Kendall · Yorba Linda, CABuilt 1991 · S/N E2632N905VPratt Raymond P · Sandia Park, NMBuilt 1974 · S/N D-9635N90628Deductionpros LLC · Longview, TXS/N A-809N90659Jones Thomas J · Casper, WYBuilt 1973 · S/N D9437N9066SPower Flow Systems Inc · Daytona Beach, FLBuilt 1978 · S/N E-1305N9067QBrabeck Mark F · Glasgow, MTBuilt 1970 · S/N D-9200N9068QPursell Robert W · Las Vegas, NVBuilt 1970 · S/N D-9199N906BFay Ryan L · Byron, MNBuilt 1961 · S/N D-6783N906QFerguson David A · Flagstaff, AZBuilt 1961 · S/N D-6803
Back to AD 99-05-13 R1 WD