N912XJ
Service difficulty reports · 245
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 = 'N912XJ' 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 = 'N912XJ' 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 REXA2015050400486Door Sill · corrodedTASK CARD 900-53-900-504 CORROSION ON RT SIDE FLOOR SEAL, RBL36, FWD OF GALLEY SERVICE DOOR NEAR FS 319.00 & BS 316.00 - 319.00, BL 36R, WL72. REPAIRED RT SIDE FLOOR SILL FWD OF GALLEY SERVICE DOOR AT FS 319.00 IAW EA 953-03419.SDR REXA2015050300485Seat Track · corrodedTASK CARD 900-53-900-506 RIGHT SEAT RAIL HAS LIGHT SURFACE CORROSION AT FS 645.00. BLENDED CORROSION ON SEAT RAIL. REMOVED .042 OF ALLOWABLE .035, FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R SEAT RAIL IAW AMM 53-00-49.SDR REXA2015050300484Seat Track · corrodedTASK CARD 900-53-900-101 RT SIDE FLOOR SEAT RAIL HAS CORROSION BETWEEN FS 349.00 & 377.00. BLENDED CORROSION ON RT FLOOR SEAT RAIL. REMOVED .062, FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R SEAT RAIL IAW AMM 53-00-49.SDR REXA2015050300483Seat Track · corrodedTASK CARD 900-53-900-506 LEFT SIDE SEAT RAIL AT FS 811 HAS CORROSION. SIDE SEAT TRACK AT FS 811 & FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R SEAT TRACK IAW AMM 53-00-49.SDR REXA2015050300482Seat Track · corrodedTASK CARD 900-53-900-506 LEFT SEAT RAIL HAS CORROSION AT FS 661 + 62. MECH REMOVED CORROSION & FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R SEAT TRACK IAW AMM 53-00-49.SDR REXA2015050300481Seat Track · corrodedTASK CARD 900-53-900-504 CORROSION ON FWD END OF LT SIDE FLOOR SEAT RAIL, LBL9, NEAR FS 374.00, BS 374.00 & WL 72.00. MECH REMOVED DAMAGE FROM LT FLOOR SEAT TRACK NEW FS 374.00 & FOUND TO BE OUT OF LIMITS IAW REO 670-53-00-013. R & R TRACK IAW AMM 53-00-49.SDR REXA2015042900466Escape Rope · frayedTASK CARD 900-25-260-100 LT EMER ESCAPE ROPE FRAYED NEAR ATTACH POINT. R & R LT EMER ESCAPE ROPE IAW AMM 25-63-04.SDR REXA2015040600374Battery · dischargedCAPTAINS SIDE EMER LIGHT INOPERATIVE. R &R BATTERY IAW 25-61-00. OPERATIONS CHECKED GOOD.SDR REXA2015032600344Gcu · malfunctionedGEN 1 OFF LINE TURNED MAGENTA IN FLIGHT. R & R 1 GCU IAW AMM 24-11-07. OPERATIONS CHECKED GOOD. OK FOR SERVICE. PN OFF & ON 766283C, SN OFF 1397 & SN ON 2191.SDR REXA2015011600058Light · missingEXIT ROW 13 A - B EMER EXIT ROW LIGHTING STRIP MISSING. ROBBED 10 INCH SECTION FROM 1A LT SIDE. ROBBED 5 INCH SECTION AT RT SIDE 20CD. INSTALLED LIGHTING STRIP AT ROW 13AB. DEFERRED ROBBED SECTIONS IAW MEL 33-51-1G MC 96579 ADVISED. CAT C ENTERED INTO MM0SDR REXA2015011200018Light · unsecureROW 13A EMERGENCY LIGHT CAME OFF. SECURED THE EMERGENCY LIGHT IAW AMM 33-51-00.SDR REXA2015010800005Light · unsecure13B FLOOR EMERGENCY LIGHT IS NOT SECURE. SECURED LIGHT IAW AMM 33-51-01. OK FOR SERVICE.SDR REXA2014110501110Light · unsecureEMERGENCY FLOOR STRIPES IN EXIT ROW 13 LT & RT SIDE PULLED UP. REINSTALLED EMER FLOOR TRACKS ON ROW 13 SEAT AB IAW AMM 33-51-01.SDR REXA2014102001056Battery · dischargedFIRST OFFICER`S SIDE EMERGENCY FLASHLIGHT NOT CHARGING, RED LIGHT IS NOT FLASHING. INSTALLED NEW BATTERY IAW AMM 25-61-02. OPS CHECKED GOOD.SDR REXA2013121202223Flashlight · inoperativeFLIGHT ATTENDANT`S REPORTS FLASHLIGHT ON GALLEY SERVICE DOOR, RED LIGHT NOT FLASHING. DEFERRED FLASHLIGHT IAW MEL 25-61-4 MX NOTIFIED 53431 ENTERED INTO MM02 & PLACARD PLACED. R & R FLIGHT ATTENDANT’S EMERGENCY FLASHLIGHT ASSEMBLY BY SERVICE DOOR IAW AMM 25-6SDR REXA2013112502187Life Vest · missingTHREE INFANT LIFE VEST MISSING FROM WARDROBE CLOSET. INSTALLED THREE VEST PN P0640-101.SDR REXA2013091301826Retainer · dentedFWD CARGO DOOR LOWER OUTER SEAL RETAINER IS DENTED AND GOUGED. REPLACED FWD CARGO DOOR LOWER OUTER SEAL RETAINER IAW SRM 51-42-06, LEAK TEST OF FWD CARGO DOOR GOOD IAW AMM 52-00-00-790-801, REF MM409 282677.SDR REXA2013091301825Retainer · bentFWD CARGO DOOR INNER LOWER SEAL RETAINER IS BENT. REPLACED FWD CARGO DOOR INNER LOWER SEAL RETAINER WITH NEW IAW AMM 52-35-07 LEAK TEST OF FWD CARGO DOOR GOOD IAW AMM 52-00-00-790-801.SDR REXA2013091301824Structure · gougedCLUSTER OF GOUGES ON HINGE INBD SEAL AREA OF PAX DOOR. REMOVED GOUGES ON INBD SEALANT PAX DOOR AND IS IN LIMITS IAW EO R53481.SDR REXA2013091202081Doubler · chafedLT LWR, LT LOWER TRANSCOWL COAMING DOUBLER L/E CHAFED. REPAIRED LOWER TRANSCOWL COAMING DOUBLER IAW REO 670-54-21-1028 C/W FUNCTIONAL TEST OF THE T/R SYS NO DEFECTS NOTED IAW AMM 78-30-00-720-801, PN CR3522-5-3.SDR REXA2013091202080Doubler · chafedLT UPPER TRANSCOWL COAMING DOUBLER L/E CHAFED. REPAIRED LT UPPER TRANSCOWL COAMING DOUBLE L/E IAW REQ 670-54-21-1028 FUNCTIONAL TEST OF THE T/R SYS GOOD IAW AMM 78-30-00-720-801.SDR REXA2013091202079Access Panel · chafedRIGHT AILERON ACCESS PANEL 699CB IS CHAFED. REPAIRED RT AILERON ACCESS PANEL 699CB IAW REO 690-57-61-093.SDR REXA2013091201823Structure · damagedLEFT WING NR 1 SLAT IS GOUGED ON T/E AT APPROXIMATELY WS 128. REPAIRED LT WING NR 1 SLAT T/E IAW REO 690-57-42-263.SDR REXA2013091201822Floorbeam · corrodedLT BS 280 FLOORBEAM HAS CORROSION AT LBL9, TOP SIDE. REPAIRED CORROSION DAMAGE IAW EO R53482.SDR REXA2013091201821Shutoff Valve · crackedUPPER FLANGE CRACKED ON LT SHUTOFF VALVE IN AFT CARGO BAY. R & R LT SHUTOFF VALVE IAW AMM 21-55-02. PERFORMED OPS TEST OF SHUTOFF VALVE. OPS TESTED GOOD IAW AMM 21-55-02.SDR REXA2013091201820Strap · corrodedFWD E&E BAY FS 280 CIRCUMFERENTIAL STRAP CORRODED. REPAIRED AND FOUND WITHIN LIMITS IAW SRM 51-21-06.SDR REXA2013091201819Mount · chafedRT WHEEL WELL OTBD BODY TO WING MOUNT CHAFED. BLENDED CHAFE O/H BODY TO WING MOUNT AND IS IN LIMITS IAW EO R57152.SDR REXA2013091201818Mount · chafedLT WHEEL WELL OTBD BODY TO WING MOUNT CHAFED. BLENDED CHAFE ON LT BODY TO WING MOUNT AND IS IN LIMITS IAW EO R57152.SDR REXA2013091201817Plate · wornPASSENGER DOOR, FWD UPPER CENTERING PLATE IS WORN. REPAIRED WEAR DAMAGE AND FWD UPPER CENTERING PLATE ON PAX DOOR IAW EOR52093 GAGE CHECK GOOD IAW MM 52-11-00, REF MM409 282682. PN MS20426AD6-8.SDR REXA2013091102078Access Panel · chafedRIGHT AILERON ACCESS PANEL 699BB IS CHAFED. REPAIRED RT AILERON ACCESS PANEL 699BB IAW REO 690-57-61-093.SDR REXA2013091102077Skin · chafedRIGHT AILERON L/E SKIN IS CHAFED AT WS 353 AND 314.5. REPAIRED CHAFED AREAS ON RT AILERON L/E SKIN IAW REO 690-57-61-093.SDR REXA2013091102076Panel · chafedPANEL 622AR HAS CHAFED METAL ALONG L/E. REMOVED CHAFES IAW REO 690-57-41-114 ON PANEL 622AR AND IS WITHIN LIMITS IAW REO 690-57-41-114.SDR REXA2013091101816Skin · chafedRIGHT AILERON L/E SKIN IS CHAFED AT WS 353 AND 314.50. REPAIRED CHAFED AREAS ON RT AILERON L/E SKIN IAW REO 690-57-61-093.SDR REXA2013091101815Access Panel · chafedLEFT INBD FLAP VANE, INBD ACCESS PANEL 584ET IS CHAFED. R & R WITH NEW PANEL 584ET IAW SRM 51-40-11, PN CC670-4027-3.SDR REXA2013091101814Channel · damagedWHILE INSTALLING RT INBD WING L/E, NUT PLATE CHANNEL FOUND TO BE DAMAGED. R & R NUT PLATE CHANNEL IAW SRM 51-42-06.SDR REXA2013091101813Skin · chafedAFT LOWER SKIN CHAFED AT BS 913, REPAIRED SKIN IAW EO R53480.SDR REXA2013091101812Hinge · gougedTHE 11TH HINGE LUG ON THE DOOR HINGE IS GOUGED. REPAIRED 11TH HINGE LUG ON DOOR HINGE IAW EO R52092, MM 409 282683.SDR REXA2013091101811Hinge Fitting · gougedSECOND HINGE LUG ON FUSELAGE SIDE OF PAX DOOR IS GOUGED. REPAIRED HINGE LUG ON FUSELAGE SIDE OF PAX DOOR IAW EO R53481.SDR REXA2013091101810Skin · damagedRT MAIN GEAR DOOR LOWER INNER SKIN PUNCTURED. REPAIRED RT MAIN CARGO DOOR LOWER INNER SKIN IAW REO 690-52-82-086 GAP CHECK GOOD IAW MM 32-12-01.SDR REXA2013091101809Door · damagedRT MAIN GEAR DOOR OTBD UPPER AFT EDGE DAMAGED. REPAIRED RT MAIN CARGO DOOR OTBD UPPER AFT EDGE IAW REO 690-52-82-086, GAP CHECKED GOOD IAW MM 32-12-01.SDR REXA2013091101808Access Panel · damagedLT WING FUEL PANEL 541CB DAMAGE. REPAIRED LT WING FUEL PANEL 541CB IAW REO 690-57-22-018.SDR REXA2013091002075Web · gougedMID CARGO DOOR INNER WEB IS CHAFED ON LOWER FWD AND AFT CORNERS. REPAIRED MID CARGO DOOR INNER WEB LOWER AND FWD AND AFT CORNERS IAW REO 690-52-35-106, REF MM409 282665, PN CR3213-5-3.SDR REXA2013091002074Web · gougedFWD CARGO DOOR INNER WEB IS GOUGED ON LOWER FWD AND AFT CORNERS. REPAIRED FWD CARGO DOOR INNER WEB LOWER FWD AND AFT CORNERS IAW REO3 690-52-35-107, REF MM409, 282664.SDR REXA2013091001807Intercostal · corrodedFWD E & E BAY INBD INTERCOSTAL CORRODED AT FS 364, REPAIRED RT INBD INTERCOSIAL AND FOUND WITHIN LIMITS IAW SRM 51-21-06.SDR REXA2013091001806Intercostal · corrodedFWD E & E BAY LT INBD INTERCOSTAL CORRODED AT FS 364, REPAIRED LT INBD INTERCOSTAL & FOUND WITHIN LIMITS IAW SRM 51-21-06.SDR REXA2013091001805Stringer Splice · corrodedFWD E & E BAY STRINGER 25L SPLICE CORRODED AT FS 33, REPAIRED & FOUND WITHIN LIMITS IAW SRM 51-21-06.SDR REXA2013091001804Doubler · corrodedFWD E & E BAY TCAS DOUBLER CORRODED. REPAIRED TCAS DOUBLER FOUND WITHIN LIMITS IAW SRM 51-21-06.SDR REXA2013091001803Floor Support · corrodedFWD E&E BAY FS 280 AFT LOWER PANEL LANDING CORRODED. REPAIRED AND FOUND WITHIN LIMITS IAW SRM 51-21-06.SDR REXA2013091001802Arm · gougedMID CARGO DOOR FWD LOWER HINGE ARM IS GOUGED. COMPLIED WITH REO 690-52-35-105 TO REPAIRED MID CARGO DOOR FWD LOWER HINGE ARM.SDR REXA2013091001801Arm · gougedFWD CARGO DOOR AFT LOWER HINGE ARM IS GOUGED. COMPLIED WITH REO 690-52-35-104 IN REPAIR OF FWD CARGO DOOR AFT HINGE ARM REF MM.
Back to N912XJ