N761AJ
Service difficulty reports · 228
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N761AJ' AND registry_match = 'registration' ORDER BY difficulty_date DESC"
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.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N761AJ' AND registry_match = 'registration' ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR AALA20091216DFW12Lamp · burned outEMERGENCY LIGHT AT SEAT 33G INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW11Lamp · burned outEMERGENCY LIGHT AT SEAT 31G INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW10Lamp · burned outEMERGENCY LIGHT AT SEAT 33G INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW09Lamp · burned outEMERGENCY LIGHT AT SEAT 34G INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW08Lamp · burned outEMERGENCY LIGHT AT SEAT 35G INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW07Lamp · burned outEMERGENCY LIGHT AT SEAT 36G INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW06Light · inoperativeEMERGENCY LIGHT AT SEAT 37G INOPERATIVE. REPLACED LIGHT ASSEMBLY.SDR AALA20091216DFW05Lamp · burned outEMERGENCY LIGHT AT SEAT 41G INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW04Light · damagedEMERGENCY LIGHT AT SEAT 36C INOPERATIVE. REPLACED LIGHT ASSEMBLY.SDR AALA20091216DFW03Lamp · burned outEMERGENCY LIGHT AT 31C INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW02Lamp · burned outEMERGENCY LIGHT AT 24C INOPERATIVE. REPLACED LAMP.SDR AALA20091216DFW01Lens · damagedEMERGENCY LIGHT AT LT NR 1 DOOR AREA IS MISSING LENS AND IS DAMAGED. REPLACED LIGHT ASSEMBLY.SDR AALA20091216DFW14Lamp · burned outEMERGENCY LIGHT AT SEAT 36C INOPERATIVE. REPLACED LAMP.SDR AALA20091111MIA09Shroud · missingEMERGENCY LIGHT SHROUD MISSING AT SEAT 26G. INSTALLED NEW SHROUD AT SEAT 26G SEAT MOUNTED EMERGENCY LIGHT.SDR AALA20091111MIA08Shroud · missingEMERGENCY LIGHT SHROUD MISSING AT SEAT 20G. INSTALLED NEW SHROUD ON SEAT 20G EMERGENCY LIGHT.SDR AALA20091111MIA07Oxygen Bottle · low pressureCREW O2 BOTTLE PRESSURE LOW. REPLACED CREW O2 BOTTLE PER MM.SDR AALA20091111MIA06Shroud · missingEMERGENCY LIGHT SHROUD MISSING AT SEAT 38G. REPLACED SHROUD AT SEAT 38G.SDR AALA20091111MIA05Lens · missingEMERGENCY LIGHT AT SEAT 35C MISSING LENS. REPLACED LENS AT SEAT 35C.SDR AALA20091111MIA04Shroud · missingEMERGENCY LIGHT SHROUD AT SEAT 26G MISSING. REPLACED SHROUD AT SEAT 26G.SDR AALA20091111MIA03Lamp · burned outEMERGENCY LIGHT AT SEAT 35C INOPERATIVE. REPLACED LAMP AT SEAT 35C.SDR AALA20091111MIA02Shroud · missingEMERGENCY LIGHT AT SEAT 20G MISSING SHROUD. REPLACED SHROUD AT SEAT 20G.SDR AALA20091102TUL12Lens · missingEMERGENCY LIGHT AT SEAT 30G HAS LENS MISSING. REPLACED LENS.SDR AALA20091016MIA06Light · missingEMERGENCY LIGHT AT SEAT 30G HAS LAMPS MISSING. REPLACED LAMPS.SDR AALA20091016MIA08Strap · missingEMERGENCY FLASHLIGHT AT RIGHT NUMBER TWO DOOR TAMPER STRAPS MISSING. INSTALLED TAMPER STRAP AT RIGHT NUMBER TWO DOOR.SDR AALA20091016MIA07Pouch · looseLIFE VEST POUCH AT SEAT 20G HANGING DOWN. SECURED LIFE VEST POUCH AT 20G.SDR AALA20091016MIA05Lens · missingEMERGENCY LIGHT AT AFT GALLEY MISSING LENS FOR EMERGENCY LIGHT. REPLACED AFT GALLEY EMERGENCY LIGHT LENS.SDR AALA20091016MIA04Light · inoperativeEMERGENCY LIGHT AT SEAT 10G INOPERATIVE. REPLACED LAMP.SDR AALA20091016MIA03Light · inoperativeOVERHEAD EMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR INOPERATIVE. REPLACED LAMP.SDR AALA20091016MIA02Light · inoperativeEMERGENCY LIGHT AT SEAT 12D INOPERATIVE. REPLACED LAMP AT 12D.SDR AALA20091016MIA01Lens · missingEMERGENCY LIGHT AT SEAT 4G MISSING LENS. REPLACED LENS.SDR AALA2009061800005Lens · missingLHR - EMERGENCY LIGHT LENS MISSING FROM SEAT 37G. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 37G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009061800004Lens · missingLHR - EMERGENCY LIGHT LENS MISSING FROM SEAT 31G. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 31G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009061800003Lens · missingLHR - EMERGENCY LIGHT LENS MISSING FROM SEAT 44C. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 44C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009061800002Lens · missingLHR - EMERGENCY LIGHT LENS MISSING FROM SEAT 30C. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 30C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009060900001Lens · missingDFW - RIGHT NUMBER ONE DOOR AF EMERGENCY LIGHT LENS MISSING. REPLACED LIGHT ASSEMBLY FOR RIGHT NUMBER ONE DOOR AF EMERGENCY LIGHT.SDR AALA200820097Tab · damagedLT SIDE OF RUDDER TAB HAS DAMAGE 14 INCHES FROM LEADING EDGE AND 5 INCHES ABOVE BOTTOM OF TAB, DIAMETER .5 INCHES; REPAIR NR AALA20820097 ENTERED IN ERROR SHOULD READ, AALA200820097.SDR AALA20820097Tab · damagedLT SIDE OF RUDDER TAB HAS DAMAGE 14 INCHES FROM LEADING EDGE AND 5 INCHES ABOVE BOTTOM OF TAB, DIAMETER .5 INCHES, REPAIRED IAW SRM 51-70-04-2R FIGURE 201-6 CURED PER FIG 211 SHEET 1.SDR AALA200820096Tab · damagedRUDDER HAS DAMAGE 1.25 INCH IN DIAMETER 11 INCH FROM LEADING EDGE AND 8 INCH FROM BOTTOM SIDE OF TAB RT SIDE. RUDDER REPAIRED IAW SRM 51-70-04-2R AND EA NUMBER COMP 5T-00506 CURED PER FIG 211.SDR AALA200820095Tab · damagedRT RUDDER TAB HAS TWO INCH LONG CREASE 17.5 INCH FROM LEADING EDGE AND 6.5 INCH FROM BOTTOM SIDE OF TAB. RT RUDDER TAB REPAIRED IAW SRM 51-70-04-2R AND EA COMP NUMBER 5T-005062 CURED PER FIG 211.SDR AALA200802448ALamp · burned outLHR - CAPTAINS SIDE DOME LIGHT INOPERATIVE. REPLACED LAMP FOR CAPTAINS SIDE DOME LIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802275Lens · missingEMERGENCY LIGHTS AT SEAT 20G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHTS AT SEAT 20G. SYSTEM GROUND CHECKED NORMAL OPERATION. (K)SDR AALA200801505Lens · missingDFW - EMERGENCY LIGHT AT SEAT 26C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA200801504Light · damagedDFW - EMERGENCY LIGHT AT LEFT NUMBER ONE GALLEY CLOSET BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE GALLEY CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA200800417Light · damagedDFW - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR CLOSET AREA DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR CLOSET AREA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800416Light · damagedDFW - EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR AISLE DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072544Light · brokenDFW - EMERGENCY LIGHT AT FIRST CLASS GALLEY RIGHT FORWARD FLOOR BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FIRST CLASS GALLEY RIGHT FORWARD FLOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072074Lamp · inoperativeJFK - FOUND EMERGENCY LIGHT AT FORWARD SEAT 4D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT FORWARD SEAT 4D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072073Lens · missingJFK - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072072Lens · missingJFK - EMERGENCY LIGHT AT SEAT 31G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 31G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072071Lens · missingJFK - EMERGENCY LIGHT AT SEAT 21C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N761AJ