N794AN
Service difficulty reports · 276
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 = 'N794AN' 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 = 'N794AN' 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 AALA20110121DFW05Light · inoperativeROW 24C ESCAPE PATH LIGHT MISSING LENS AND INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR ROW 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110121DFW04Light · missingROW 21C ESCAPE PATH LIGHT MISSING LAMP AND LENS. REPLACED LIGHT ASSEMBLY FOR SEAT 21C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110121DFW03Lens · missingCEILING ESCAPE PATH LIGHT AT SEAT 12D MISSING LENS. REPLACED LENS FOR CEILING ESCAPE PATH LIGHT AT SEAT 12D. OPS CHECK NORMAL.SDR AALA20110121DFW02Battery Pack · dischargedCEILING ESCAPE PATH LIGHT LEFT SIDE FROM LEFT NUMBER 2 DOOR TO ROW 12D INOPERATIVE. REPLACED BATTERY PACK M33099. OPS CHECK NORMAL.SDR AALA20110121DFW01Light · inoperativeLEFT NUMBER 3 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR EXTERIOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20101104TUL10Lens · missingROW 39C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 39C ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101104TUL09Light · missingROW 21C ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR 21C ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101104TUL08Light · missingROW 23G ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR 23G ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101104TUL06Lens · missingROW 23G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR 23G ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101103DFW08Light · missingROW 26C ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR 26C ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101103DFW07Lens · missingROW 21C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR 21C ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20101103DFW06Lens · missingROW 44C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR 44C ESCAPE PATH LIGHT. OPS CHECKS NORMAL.SDR AALA20100825TUL01Light · missingSEAT 38C MISSING EMERGENCY LIGHT LAMP. REPLACED SEAT 38C EMERGENCY LIGHT LAMP. OPS CHECKED NORMAL.SDR AALA20100825DFW12Light · inoperativeRIGHT NUMBER 2 DOOR AFT EMERGENCY EXIT SIGN LAMP INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 2 DOOR AFT EMERGENCY EXIT SIGN. OPS CHECKED NORMAL.SDR AALA20100825DFW11Sign · inoperativeLEFT NUMBER 2 DOOR AFT EMERGENCY EXIT SIGN LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 DOOR AFT EMERGENCY EXIT SIGN. OPS CHECKED NORMAL.SDR AALA20100825DFW10Lens · missingSEAT 38C MISSING EMERGENCY LIGHT LENS. REPLACED LENS FOR SEAT 38C EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100825DFW09Light · inoperativeLEFT NUMBER 3 DOOR AFT EMERGENCY EXIT SIGN LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR AFT EMERGENCY EXIT SIGN. OPS CHECKED NORMAL.SDR AALA20100729DFW01Light · inoperativeEMERGENCY EXIT LIGHT AT LEFT NUMBER 3 DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT LEFT NUMBER 3 DOOR. OPS CHECKED NORMAL.SDR AALA20100606DFW01Light · missingSEAT 31G EMERGENCY LIGHT MISSING LAMPS. REPLACED LAMP FOR SEAT 31G EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100225TUL14Lens · missingEMERGENCY LIGHT AT SEAT 32G MISSING LENS. REPLACED LENS.SDR AALA20100122MIA06Light · inoperativeEMERGENCY LIGHT AT OVERHEAD LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED LAMP.SDR AALA20100122MIA05Light · looseEXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER THREE DOOR INOPERATIVE. SECURED LAMP AT EXTERIOR RIGHT NUMBER THREE DOOR.SDR AALA20100122MIA04Light · looseEXTERIOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR INOPERATIVE. SECURED LAMP AT EXTERIOR RIGHT NUMBER ONE DOOR EMERGENCY LIGHT.SDR AALA20100122MIA03Light · damagedAFT GALLEY MIDDLE EMERGENCY LIGHT ASSEMBLY INOPERATIVE. REPAIRED AFT GALLEY CENTER EMERGENCY LIGHT ASSEMBLY.SDR AALA20100122MIA02Light · inoperativeEMERGENCY LIGHT AT SEAT 32G INOPERATIVE. REPLACED LAMP.SDR AALA20100102MIA07Lens · looseEMERGENCY LIGHT AT MID GALLEY HAS LOOSE LENS. SECURED LENS.SDR AALA20100102MIA06Lens · looseEMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR HAS LOOSE LENS. SECURED LENS.SDR AALA20100102MIA05Lens · looseFIRST CLASS GALLEY EMERGENCY LIGHT AT LOWER LEFT HAND HAS LOOSE LENS. SECURED LENS IN FIRST CLASS GALLEY.SDR AALA20100102MIA04Light · inoperativeEMERGENCY LIGHT AT OVERHEAD SEAT 9C INOPERATIVE. REPLACED LAMP.SDR AALA20100102MIA03Light · inoperativeEMERGENCY LIGHT AT SEAT 30C INOPERATIVE. REPLACED LAMP.SDR AALA20100102MIA02Light · inoperativeEMERGENCY LIGHT AT SEAT 25C INOPERATIVE. REPLACED LAMP.SDR AALA20100102MIA01Light · inoperativeEXTERNAL EMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR INOPERATIVE. REPLACED LAMP.SDR AALA20091207JFK01Light · brokenEMERGENCY LIGHT BROKEN AT OUTBOARD LEFT SIDE OF FIRST CLASS GALLEY COAT CLOSET. REPLACED EMERGENCY LIGHT ASSEMBLY.SDR AALA20091110DFW02Lens · missingSEAT MOUNTED EMERGENCY LIGHT AT SEAT 23G LENS MISSING. REPLACED MISSING LENS AT SEAT 23G. OPS CHECKS GOOD.SDR AALA20091202TUL09Light · inoperativeEMERGENCY LIGHT AT SEAT 1B INOPERATIVE. REPLACED LAMP FOR SEAT 1B.SDR AALA20091102MIA01Light · inoperativeEMERGENCY LIGHT AT SEAT 20B INOPERATIVE. RELAMPED SEAT 20B.SDR AALA20090929ORD01Actuator · leakingSHORTLY AFTER TAKEOFF, LOST RIGHT HYDRAULIC SYSTEM QUANTITY. RETURNED ORD, LANDED UNEVENTFULLY AND TAXIED TO GATE UNDER OWN POWER. UNDER INITIAL EXAMINATION BY GATE MECHANICS, FOUND FLUID LEAK IN AREA OF LEFT FLAPERON. FOUND LEFT OUTBOARD FLAPERON ACTUATOR SDR AALA20090709NRT01Light · looseEMERGENCY LIGHT FIXTURE ON EDGE OF FIRST CLASS CLOSET DOOR NEAR 1L COMES OUT OF CLOSET MOUNT WHEN CLOSET DOOR OPENS AND CLOSES. SECURED EMERGENCY LIGHT FIXTURE ON FIRST CLASS CLOSET DOOR NEAR 1L. LIGHT OPS CHECK OK.SDR AALA2009041000002Slide · unwanted deployMIA LEFT NUMBER ONE DOOR SLIDE INADVERTANTLY DEPLOYED AT HANGER. REPLACED LEFT NUMBER 1 DOOR SLIDE.SDR AALA200803200Lamp · wrong partDFW - EMERGENCY LIGHT AT SEAT 24G HAS WRONG LAMPS. REPLACED LAMPS AT SEAT 24G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802713Light · inoperativeLHR EMERGENCY LIGHT AT SEAT 11G FORWARD INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 11G. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA200802466Lens · detachedEMERGENCY LIGHT LENS AT FIRST CLASS COAT CLOSET IS DETACHED. REPLACED LENS FOR EMERGENCY LIGHT. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802305Lens · missingMIA EMERGENCY LIGHT AT SEAT 33G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 33G. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802304Lamp · inoperativeMIA EMERGENCY LIGHT AT OVERHEAD SEAT 22G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT 22G. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802303Lens · brokenMIA EMERGENCY LIGHT AT SEAT 20C HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802302Lamp · brokenMIA EMERGENCY LIGHT AT SEAT 20C HAS BROKEN LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802151Lens · missingEZE EMERGENCY LIGHT AT SEAT 23G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802135Lens · missingORD EMERGENCY LIGHT AT SEAT 26G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26G. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802134Lens · missingORD EMERGENCY LIGHT AT SEAT 36C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 36C. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802133Lens · missingORD EMERGENCY LIGHT AT SEAT 20C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPS.
Back to N794AN