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.

N4919BKirvida James Mitchell · New Richmond, WIS/N D-4257N491BAirside Kc LLC · Riverside, MOBuilt 1974 · S/N TE-1012N491PDAir Ventures Awaits LLC · Middletown, DEBuilt 1974 · S/N M-1574N491WMRenlim Aviation LLC · Brookhaven, GABuilt 1985 · S/N TJ-491N4920BHain Christopher O · Merritt Island, FLBuilt 1955 · S/N D-4325N492TZuestek Inc · Diana, TXBuilt 1960 · S/N D-6597N49301Blue Sky Adventures LLC · Hanover, PAS/N 250N493DVSatterfield Thomas J · Ewing, ILBuilt 1979 · S/N TJ-218N493KPCatalano Gerry · Shingle Springs, CABuilt 1988 · S/N CE-1231N493WLarreategui Patrick A · Dayton, OHBuilt 2003 · S/N E-3493N4944CCoke Richard · Bedford, TXS/N BG-283N4945CFandango Ranch Operating Co Inc · Bend, ORS/N BG-234N4945MMidland College · Midland, TXBuilt 1978 · S/N TJ-145N4946BTippetts Kelly · Richmond, KSS/N CH-346N4948BKrause Aviation LLC · Geneva, ILBuilt 1955 · S/N DH-4N494AStotlar William B · Pinckneyville, ILBuilt 1967 · S/N TE-370N494BStutzman Frank C · Caldwell, IDBuilt 1948 · S/N D-1514N494PGarrett Jacob Y · West Plains, MOBuilt 1993 · S/N CE-1738N4951VBranam John R · Clinton, TNBuilt 1952 · S/N D-3197N4956MMurray Timothy · Orlando, FLBuilt 1978 · S/N CE-781N495GCCunningham John · Naperville, ILBuilt 1981 · S/N E-1876N496TWalker Stephen E · Mcgregor, TXBuilt 1961 · S/N D-6684N4970MAerotrust Services Corp · Wilmington, DEBuilt 1978 · S/N E-1277N4971BOlstad Christopher A · El Cajon, CABuilt 1958 · S/N D-5551N4972MZenith Air LLC · Salome, AZBuilt 1978 · S/N E-1275N4975BYates Gary · Punta Gorda, FLS/N D-5567N4979MLager Eric Willard · Palos Park, ILBuilt 1978 · S/N E-1281N497ABedell William F H · Church Hill, MDBuilt 1968 · S/N TE-547N497BWillis James R · Belleview, FLBuilt 1948 · S/N D-1518N497DTPond Fred C · Van Wert, OHS/N E-3569N497EBFl Scapes Inc · Panama City Beach, FLBuilt 1999 · S/N E-3296N497LGulf Sierra Air Corp · Portola Valley, CABuilt 1984 · S/N E-2156N4982NReirdon Michael Shawn · El Cajon, CABuilt 1953 · S/N 53-4095N4984Hobschaidt Kurt J · Pittstown, NJBuilt 1955 · S/N JS-611N4984MBas Part Sales LLC · Greeley, COBuilt 1978 · S/N D-10137N4985Crawford Loel H · La Follette, TNBuilt 1953 · S/N 34-125N4986MLaney Construction Co Inc · Murphy, NCBuilt 1978 · S/N E-1282N4989MRistevski Bill · Vacaville, CABuilt 1978 · S/N D-10140N499Dancer Thomas M · Dallas, TXBuilt 1954 · S/N D-3963N4991MOakview Homes LLC · Sullivan, MOBuilt 1978 · S/N TJ-146N4998BMclenaghan Alvin N · Phoenix, AZBuilt 1956 · S/N D-4516N4999MStolutions LLC · Lexington Park, MDBuilt 1978 · S/N TC-2143N499DLCjrr Consulting LLC · Denver, COS/N EA-58N499DSDelta Sierra Aviation · Wilmington, DEBuilt 1967 · S/N D-8316N499LGear Robert Lee III · Paradise Valley, AZBuilt 1961 · S/N LC-87N499MBCook Joshua D - Trustee · Nashville, TNBuilt 1964 · S/N D-7587N499TCLieberman Richard M · Hellertown, PABuilt 1978 · S/N TC-2136N499ZGold Leaf Aviation LLC · Mount Airy, NCBuilt 1962 · S/N TC-281N49AMXsurgo LLC · Brentwood, TNBuilt 1976 · S/N P-406N49CAMagarin Aircraft LLC · Haslet, TXBuilt 1961 · S/N TC-214
Back to AD 99-05-13 R1 WD