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.

N8244EScala Peter M · Port Orange, FLS/N BG-68N8245DBrozenske Donald A Trustee · Wenham, MABuilt 1991 · S/N CE-1570N8245EWinder Gary W Jr · Thornton, COS/N G-713N8245JSln Aviation LLC · Salina, KSBuilt 1991 · S/N E-2650N8246VCaliber Construction Inc · Columbia, KYBuilt 1991 · S/N CE-1620N8247AQuality Kiln & Dryer Inc · Oakdale, LABuilt 1991 · S/N CE-1625N8247DIndy Air Sales LLC · Anderson, INBuilt 1957 · S/N D-5347N8248KPlane Haven LLC · Kalispell, MTBuilt 1991 · S/N E-2678N8249EFleming Carol A · Torrance, CAS/N BG34N824GFDavis Aviation Inc · Brandon, MSBuilt 1957 · S/N EH43N824PJDowney Joseph E · University City, MOBuilt 1976 · S/N M-1867N8250RM O S T Express · Franklin, TNS/N CE-1734N8252TRegistered aircraftBuilt 1990 · S/N CE-1545N8253CAl Stevens Construction LLC · Overland Park, KSBuilt 1990 · S/N CE-1546N8253NTejas Aviation Services LLC · Wilmington, DEBuilt 1993 · S/N CE-1743N8254DWest Pacific Air LLC · Spokane, WABuilt 1991 · S/N EA-524N8255ESouth Road Partners Inc · Kentfield, CABuilt 1991 · S/N CE-1630N8256HGj Flight Group LLC · Newark, DEBuilt 1991 · S/N E-2664N8257DWhicker Jacob Edward · Willard, UTBuilt 1957 · S/N D-5374N8258DMatthew Avionics Testing & Technical Support LLC · Stevensville, MTBuilt 1957 · S/N D-5361N8259AParisien Robert · Bow, NHS/N EA-529N8259CShepard Christopher N · Westerville, OHS/N CE-1763N8259DBlack Hunter F · Blanding, UTBuilt 1957 · S/N D-5362N8259EAtlanta Human Performance Center Inc · Mableton, GABuilt 1992 · S/N CE-1641N8259LFriendly Air LLC · Tampa, FLBuilt 1992 · S/N CE-1642N825AJJarvis Jayson S · Pinehurst, NCBuilt 1977 · S/N TC-2050N825ALN825al LLC · Freeport, NYBuilt 1969 · S/N M-1187N825ECPeterson Air LLC · Chisago City, MNBuilt 1999 · S/N E-3272N825EGFlying Eagle LLC · Wilmington, DEBuilt 1976 · S/N CE-668N825JFVendito LLC · Lewes, DEBuilt 1986 · S/N E2329N825VGarmin At Inc · Salem, ORBuilt 1977 · S/N E-963N8261DGrimmett Carl W · Gravois Mills, MOBuilt 1957 · S/N D-5366N8261K8th Street Aviation LLC · Urbandale, IABuilt 1992 · S/N E-2690N8261VTds Airpro LLC · Shreveport, LABuilt 1992 · S/N E-2691N8262DMistarz Bruce E · Gainesville, GABuilt 1992 · S/N CE-1645N8263ASullivan Larry R · Tranquillity, CABuilt 1993 · S/N CE-1730N8263DKroll Douglas W · Brighton, COBuilt 1957 · S/N D-5387N8263VPrecision Service Mtr Inc · Addison, ILBuilt 1990 · S/N EA-504N8265DPreston Jack Aviation LLC · Mesa, AZBuilt 1957 · S/N D-5365N8265XOzark Management Inc · Columbia, MOBuilt 1993 · S/N E-2804N8268DSmith Nafis T · Wayne, PABuilt 1957 · S/N D-5369N8268TN8268t LLC · Phoenix, AZBuilt 1990 · S/N CE-1547N8269VN8269v Inc · Lewes, DEBuilt 1993 · S/N E-2796N826MGOrten Symer Enterprises Inc · East Hampton, NYBuilt 1993 · S/N E2782N826MTG T Acft Inc · Franklin Square, NYBuilt 1979 · S/N TK-109N826RA & D Aviation LLC · Menominee, MIBuilt 1959 · S/N D-6153N826RSSpence Charles A · Midland, TXBuilt 1971 · S/N D-9272N826TBonanza H35 LLC · Greensboro, NCBuilt 1973 · S/N D-9518N826VMills Aviation Ltd · Wapakoneta, OHBuilt 1977 · S/N D-9950N8272DHenderson Will · Buffalo, SDBuilt 1957 · S/N D-5370
Back to AD 99-05-13 R1 WD