N909XJ
Service difficulty reports · 231
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 = 'N909XJ' 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 = 'N909XJ' 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 REXA2015080800778Engine · malfunctionedAFTER TAKEOFF IN CLIMB, THRUST ACCELERATING FROM 200KTS - 250KTS 6000 FT, RT ENG LOUD NOISE, YAW RT, LOSS OF OIL PRESS, ITT SPIKED, ENG FLAMED OUT N1 & N2 DECELERATION. PERFORMED EAC ENG FIRE OR SEVERE ENG DAMAGE & ALL QRH PROCEDURES. REPLACED RT ENG PN ON &SDR REXA2015061700606Battery · dischargedFLASHLIGHT NOT WORKING FWD. R & R FWD FLASHLIGHT BATTERY IAW AMM 25-61-02. COMPLETED OPERATIONS TEST IAW 25-61-00. OPERATIONS TESTED GOOD, OK FOR SERVICE.SDR REXA2015041100399Retainer · damagedTASK CARD 900-52-810-305 FWD CARGO DOOR SEAL RETAINER BENT & CRACKED IN VARIOUS AREAS. DISPLACED FWD CARGO DOOR SEAL FOR ACCESS TO AREA IAW AMM 52-35-07-000-802-A02. R & R RETAINER IAW SRM 51-42-06-001-001-A01. REINSTALLED SEAL IAW AMM 52-35-07-400-802-A02. SDR REXA2015041000398Panel · chafedTASK CARD CRJ 900 PANEL 684ET CHAFED. R & R PANEL 684ET IAW AMM 57-51-32-000-804-A01, 57-51-32-400-804-A01 & SRM 51-40-11-001-001-A01. PANEL WAS CHAFED BEYOND LIMITS SRM 57-52-01-101-001-A01.SDR REXA2015041000382Battery Pack · dischargedTASK CARD CR FLIGHT DECK RT EMER FLASHLIGHT RED CHARGED LIGHT NO LONGER FLASHING, BATTERY PN P4-01-0021 EF-1 DME 25-60-02. REPLACED FLIGHT DECK RT EMER FLASHLIGHT BATTERY PACK IAW CMM 25-60-02 PG 6001 3 0 A - F.SDR REXA2015040900397Oil Cooler · damagedTASK CARD 900-54-430-301 LEFT NACELLE LOWER HALF ACOC PAN DAMAGED. REPAIRED ACOC ON LOWER LT NACELLE IAW EO R54090 & ROUTINE 60013.SDR REXA2015040900396Block · wornTASK CARD 900-26-430-100 LEFT AFT CORE COWLING STANDOFF BLOCK TABS WORN. R & R STANDOFF BLOCK ON LT AFT CORE COWLING IAW SRM 54-13-00-201-002-A01 & REO 690-54-13-097.SDR REXA2015040900395Rub Strip · chafedTASK CARD 900-54-430-301 LT NACELLE UPPER & LOWER FWD COWL TO CORE, COWL RUB STRIPS CHAFED. REPAIRED LT NACELLE UPPER & LOWER COWL RUB STRIPS IAW SRM 54-23-00-201-007-A01.SDR REXA2015040900394Panel · chafedTASK CARD 900-57-900-300 PANEL 584EB CHAFED. R & R PANEL 584EB IAW AMM 57-51-32-000-801-A01, 57-51-32-400-801-A01 & SRM 51-40-11-001-001-A01.SDR REXA2015040900393Skin · damagedTASK CARD 900-05-900-901 RIGHT ELEVATOR TE HAS LIGHTNING STRIKE DAMAGE. REPAIRED RT ELEVATOR TE LIGHTNING STRIKE DAMAGE IAW SRM 55-21-01-201-001-A01. APPLIED PAINT TO REPAIRED AREA IAW SRM 51-25-01-001-001-A01.SDR REXA2015040900392Panel · chafedTASK CARD CRJ-900 PANEL 433BT CHAFED. DAMAGE FOUND TO BE OUT OF LIMITS .070 DEEP. REMOVED & INSTALLED STIFFENERS & SEALS FROM DAMAGED PANEL ON NEW PANEL IAW SRM 51-42-06-001-001-A01 & SRM 51-42-13-001-001-A01. OUT OF LIMITS SRM 54-12-01-101-001-A01.SDR REXA2015040800391Channel · damagedTASK CARD 900-54-440-301 RT ENG TR ALIGNMENT PINS DAMAGED. FOUND STRUCTURE UNDER RT ENG ALIGNMENT PINS BENT & CRACKED. REMOVED OTBD EDGE CHANNEL IAW SRM 51-42-06-001-001-A01 & 51-42-10-001-001-A01. INSTALLED NEW CHANNEL IAW SRM 51-42-06-001-001-A01 & 51-42-SDR REXA2015040800390Block · wornTASK CARD 900-26-440-100 RT AFT CORE COWLING STANDOFF BLOCK TABS WORN. R & R RT AFT CORE COWL STANDOFF BLOCK IAW SRM 54-12-00-201-A01.SDR REXA2015040800389Plate · wornTASK CARD 900-71-430-100 LT FWD COWL LOWER BLOW OUT DOOR HINGE & LATCH PLATE ARE WORN & THE UPPER BLOW OUT DOOR LATCH PLATE IS WORN. REMOVED LT LOWER & UPPER FWD COWL BLOW OUT DOOR LATCH PLATES IAW SRM 51-42-06-001-001-A01 & 51-42-10-001-001-A01. INSTALLED SDR REXA2015040900119Elevator · damagedRIGHT ELEVATOR STRIKE DAMAGE NEAR INBD TE. REPAIRED IAW SRM 55-21-01-201-001-A01.SDR REXA2015040700388Retainer · bentTSK CARD 900-52-810-306 CTR CARGO DOOR SEAL RETAINER BENT & BROKEN IN VARIOUS AREAS. REMOVED DAMAGED CTR CARGO DOOR SEAL RETAINER. REPAIR WITH NEW SEAL RETAINER IAW SRM 51-42-06-001-001-A01. LEAK CHECK WILL BE PERFORMED ON NR 46111 SEE ATTACHED COPY.SDR REXA2015040500387Door Sill · corrodedTSK CARD 900-53-900-504 FLOOR SILL CORRODED FROM FS 349 - 364. REPAIRED CORRODED AREA IAW CRJ 953-03362 & SRM 53-00-00-101-001-A01, 53-00-00-101-001-A01, 51-25-06-001-001-A01 & AMM 53-00-47-000-802-A01 & 53-00-47-000-807-A01 DEPTH GAUGE EXQS121 SCREW GUN 306-SDR REXA2015040400386Door Sill · corrodedTASK CARD 900-53-900-504 FLOOR SILL CORRODED FROM FS 280 - 310. REMOVED & REAPPLIED FINISHES. REMOVED CORROSION IAW SRM 51-25-06-001-001-A01, 51-25-16-001-001-A01 & 53-00-00-101-001-A01. REPAIRED THE DAMAGE AT STATION 310 IAW EA CRJ953-03361. COMPLETED EA SDR REXA2014102001068Glowstrip · detectedEXIT ROW PHOTO LUMINESCENT STRIP NEEDS TO BE ATTACHED. SECURED FLOOR TRACK LIGHTING IAW AMM 33-51-01. OK FOR SERVICE.SDR REXA2014090200856Light · missingDURING FLIGHT NOTICED ROW 12 EMER EXIT REFLECTIVE FLOOR STRIP MISSING. REPLACED MISSING FLOOR STRIP IAW 33-51-01. OPERATIONS CHECKED GOOD. OK FOR SERVICE.SDR REXA2014082800846Light · missingFLOOR TRACK LIGHTING STRIP BY SEAT 13 B IS MISSING. INSTALLED FLOOR TRACK LIGHT IN FRONT OF 13B IAW AMM 33-51-01. ACFT OK FOR SERVICE.SDR REXA2014062500630Light · missingFLIGHT ATTENDANT REPORTED MISSING EMER FLOOR LIGHTING STRIP IN FRONT OF TWO GALLEY CARTS. INSTALLED EMER FLOOR STRIP IAW AMM 33-51-01.SDR REXA2014022800244Smoke Warning · false activationDURING FLIGHT SMOKE AFT LAVATORY WARNING ILLUMINATED FOR 2 SECONDS & EXTINGUISHED. PERFORMED OPERATIONS CHECK OF AFT LAVATORY SMOKE DETECTOR IAW CRJ-900 26-16-00. OPERATIONS CHECKED GOOD NO MSG DISPLAYED, ACFT OK FOR SERVICE.SDR REXA2013122402236Flashlight · inoperativeREAR F/A JUMPSEAT FLASHLIGHT INOPERATIVE. R & R FLASHLIGHT. OPS CHECKED GOOD IAW AMM 25-61-00.SDR REXA2013120702211Lens · missingCTR AISLE AFT OVERHEAD E LIGHT RED LENS CAP MISSING. RED LENS CAP DEFERRED IAW N33-50-1 CAT E. 90 DAYS TRANSFERRED TO MM02 NOTIFIED.SDR REXA2013120302206Flashlight · inoperativeAFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT IS NOT FLASHING RED. DEFERRED AFT FLIGHT ATTENDANT FLASHLIGHT IAW CRJ900 MEL 25-61-4A CAT C MXC 821723, ENTERED INTO MMO2, PLACARD PLACED. CREW HAS FLASHLIGHTS AVAILABLE. ACFT OK FOR SERVICE.SDR REXA2013111902180Lens · missingMID CABIN EMERGENCY EXIT SIGN FWD SIDE WAS MISSING, F/A EMERGENCY CALL LIGHT. INSTALLED SERVICEABLE LENS COVER IAW AMM 33-51-07.SDR REXA2013091801830Pump · failedINBD SPOILERON & INBD FLT SPOILERS CAUTION, 2A PUMP ON HYDRAULIC PAGE INTERMITTENT YELLOW, VIBRATION FELT THROUGHOUT ACFT. HYD 2, LOW PRESSURE. 2A PUMP SHUTDOWN, HYD EDP 2A CAUTION TEMP NORMAL QUANTITY 5 PERCENT, RT ENG SHUTDOWN AND EDP 2A OFF. DEACTIVATSDR REXA2013081901829Skin · dentedLOWER FUSELAGE SKIN FS 1069.75 TO 1162, S21-22L, HAS MULTIPLE DENTS AT THE VENTRAL FIN FAIRING INTERFACE. RECONTOURED DENTED AREA TO WITHIN LIMITS CONDITION IAW REO 690-53-61-389 AND EO R53458.SDR REXA2013081901500Skin · dentedLOWER FUSELAGE SKIN PANEL, FS 1069.75 - 1162, S21-22L, HAS MULTIPLE DENTS AT THE VENTRAL FIN FAIRING INTERFACE. RECONTOURED DENTED AREA TO WITHIN LIMITS CONDITION IAW REO 690-53-61-389 AND EO R53458.SDR REXA2013081901499Skin · gougedUPON REMOVAL OF PAX DOOR LWR FWD PULL IN LEVER FOUND DOOR GOUGED BEHIND LEVER. IAW REO 690-52-11-257, REPAIRED PAX DOOR INNER SKIN & REPLACED PAX DOOR FWD FRAME.SDR REXA2013081801498Skin · crackedFWD EQUIPMENT BAY SKIN CRACKED UNDER ADG PUMP. REPAIRED FWD EQUIPMENT BAY SKIN CRACK UNDER ADG PUMP IAW EO R53460.SDR REXA2013081301834Panel · chafedPANEL 684EB IS CHAFED. REPAIRED PANEL IAW REO 690-57-52-153.SDR REXA2013081301497Arm · gougedFWD CARGO DOOR AFT LOWER HINGE ARM IS GOUGED ON AFT SIDE. REPAIRED FWD CARGO DOOR AFT LOWER HINGE ARM IAW REO 690-52-35-093.SDR REXA2013081201496Skin · chafedLEFT AILERON LOWER SURFACE L/E OTBD IS CHAFED. REPAIRED AILERON IAW EO R57139.SDR REXA2013081101495Skin · dentedLOWER FUSELAGE SKIN PANEL, FS 1162 - 1167.5 STRINGER 21-22R HAS MULTIPLE DENTS AT THE VENTRAL FIN FAIRING INTERFACE. DENTS ON LOWER FUSELAGE SKIN PANEL FOUND TO BE IN LIMITS IAW REO 690-53-71-014 AND EO R53549.SDR REXA2013081101494Skin · dentedLOWER FUSELAGE SKIN PANEL, FS 1069.75 - 1162, STRINGER 21-22R HAS MULTIPLE DENTS AT THE VENTRAL FIN FAIRING INTERFACE. RECONTOURED DENTED AREAS TO WITHIN LIMITS CONDITION IAW REO 90-53-61-389 AND EO R53548. SM-74, A-247.SDR REXA2013081101493Floor Support · corrodedDURING REMOVAL OF CORROSSION ON RT FLOOR SUPPORT FOUND CORRODED BETWEEN FS 310 - 319. R & R CORRODED AREA IAW REO 690-53-21-511 AND EO R53457 S/M-114.SDR REXA2013081101492Skin · gougedPAX DOOR LOWER SKIN PANEL BENT WITH GOUGE ON EDGE JUST FWD OF DOOR HINGE. REPAIRED PAX DOOR LOWER SKIN PANEL IAW REO 690-52-11-254 AND EO R52085 S/M-114.SDR REXA2013081001491Stringer Splice · corrodedFWD E & E BAY STRINGER SPLICE 26R CORRODED. R & R STRINGER SPLICE IAW SRM 51-42-06, PNSDR REXA2013081001490Stringer · corrodedAFTER CLEANING FOUND STRINGER 26R CORRODED, FS 295-333. R & R STRINGER IAW SRM 51-42-06.SDR REXA2013081001489Stringer · corrodedFWD E & E BAY, STRINGER 25R CORRODED FS 295 - 333. R & R STRINGER IAW SRM 51-42-06.SDR REXA2013081001488Stringer Splice · corrodedSTRINGER SPLICE 25R FOUND CORRODED FS 333 TO 364. R & R STRINGER 25R IAW SRM 51-42-06.SDR REXA2013081001487Longeron · corrodedAFTER CLEANING, FOUND LONGERON 25L CORRODED, FS 333 - 364. R & R LONGERON 25L IAW SRM 51-42-06.SDR REXA2013080901833Panel · chafedPANEL 584GB IS CHAFED. REPAIRED PANEL IAW REO 690-57-52-151 CLEARANCE CHECKED GOOD IAW REO 690-57-52-151.SDR REXA2013080901486Vane · chafedRIGHT FLAP VANE PANEL 684ET CHAFED. LOCATED AND DRILLED NEW PANEL TO REPLACE PANEL 684ET IAW SRM 51-40-11.SDR REXA2013080801485Floorbeam · corrodedFS 280 CROSSBEAM CENTER FWD ANGLE CORRODED. R & R CROSSBEAM ANGLE IAW SRM 51-42-06.SDR REXA2013080801484Floorbeam · corrodedRT FS 280 CROSSBEAM CORRODED. R & R RT FS 280 FLOORBEAM IAW EO.SDR REXA2013080801483Floorbeam · corrodedLEFT FS 280 FLOORBEAM CORRODED. R & R LT FLOORBEAM IAW EO ATR53455.SDR REXA2013080801482Bulkhead · corrodedRT FS 280 BULKHEAD LOWER WEB CORRODED. REPAIRED BULKHEAD IAW EO R53456.
Back to N909XJ