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 REXA2022071401578Frame · crackedL/H AFT OVER WING EMERGENCY EXIT DOOR HAS A SUSPECTED CRACK IN THE CAST BODY AT THE BASE OF ONE HOOK FITTING, MARKED. CUT AWAY DAMAGED AREA AND INSTALLED REPAIR DOUBLER REF. ENDEAVOR AIR EA CRJ952-13583 DATED 5/11/2022 REV IR STEP 9.SDR REXA2022071401577Seat Track · corrodedMAIN CABIN FLOOR SEAT TRACK CORRODED AT RBL9 BETWEEN FS.661+32 AND FS.693.00 INSTALLED NEW SEAT TRACK AT RBL9 BETWEEN FS.661+32 AND FS.693.00. REF. CRJ-900 AMM 53-00-49-400-801-A07SDR REXA2022071401576Seat Track · corrodedMAIN CABIN FLOOR SEAT TRACK CORRODED AT LBL9 BETWEEN FS.661+32 AND FS.693.00SDR REXA2022071401575Seat Track · corrodedTHE CABIN FLOOR SEAT TRACK AT RBL9 BETWEEN FS847+62 AND FS977 HAS MULTIPLE SPOTS OF CORROSION AND SCRATCHES. REMOVED AND REPLACED NEW FLOOR SEAT TRACK AT RBL9 BETWEEN FS847+62 AND FS977 REF CRJ900 AMM 53-00-49-000-801-A07 AND CRJ900 AMM 53-00-49-400-801-A07.SDR REXA2022071401574Seat Track · corrodedTHE CABIN FLOOR SEAT TRACK AT LBL9 BETWEEN FS847+62 AND FS977 HAS MULTIPLE SPOTS OF CORROSION AND SCRATCHES EVALUATED CABIN FLOOR SEAT TRACK AT LBL9 BETWEEN FS.847+62 AND FS.977, FOUND TO BE OUT OF LIMITS REF CRJ900 SRM 53-41-49-101-001-A02, AND 53-51-49-101-0SDR REXA2022071401573Seat Track · corrodedTHE CABIN FLOOR SEAT TRACK AT RBL9 BETWEEN FS847 AND FS847+48 HAS MULTIPLE SPOTS OF CORROSION AND SCRATCHES.SDR REXA2022071401572Seat Track · corrodedTHE CABIN FLOOR SEAT TRACK AT LBL9 BETWEEN FS847 AND FS847+48 HAS MULTIPLE SPOTS OF CORROSION AND SCRATCHES. "BLENDED-OUT DAMAGE ON CABIN FLOOR SEAT TRACK AT FS847.00 AND FS847+48, AND EVALUATED AS OUT-OF-LIMITS. FABRICATED NEW SEAT TRACK. REF. CRJ900
SRM 51-SDR REXA2022071401571Bracket · corrodedFORWARD BAGGAGE BAY DOOR SURROUND, FORWARD EDGE NUT PLATE BRACKET CORRODED. EVALUATED, CORRODED, FORWARD BAGGAGE BAY DOOR, FORWARD EDGE NUT PLATE BRACKET AS OUT-OF-LIMITS. REMOVED BRACKET, AND REPLACED WITH NEW, FABRICATED BRACKET PN: SH670-33385-9. REF. CRJ90SDR REXA2022071401570Stringer · corrodedSTGR26R CORRODED FS1031.00 – FS1047.00. INSTALLED NEW STRINGER 26R SPLICE AT APPROX. FS1031.00-FS1088.00 REF CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 51-42-21-001-001-A01 AND DWG MM690-35007 REV-USDR REXA2022071401569Former · corrodedTHE PASSENGER DOOR INTERNAL STRUCTURE'S FWD FORMER AT FS311.75 HAS CORROSION ON ITS WEB AND FLANGE BEHIND ACCESS PANEL 832FL. REMOVED AND REPLACED WITH NEW PAX DOOR FWD FORMER AT FS311.75 PER CRJ900 SRM 51-42-06-001-001-A01 & BOMBARDIER DRAWING 601R31702 REV-NSDR REXA2022071301568Intercostal · corrodedTHE PASSENGER DOOR INTERNAL STRUCTURE'S INTERCOSTAL DD6 BETWEEN FS320.163 AND FS338.963 HAS CORROSION ON ITS FLANGES AND WEB. REMOVED PAX DOOR INTERCOSTAL DD6 BETWEEN FS 320.163 AND FS 338.963, ORDERED AND RECEIVED, LOCATED AND DRILLED, AND INSTALLED NEW INTERSDR REXA2022071301567Tie Clip · crackedAFT SIDE OF BULKEAD FS1098.20 AT STRG 24L. CLIP HAS THE APPEARANCE OF A CRACK IN UPPER CORNER. REMOVED AND REPLACED CLIP WITH NEW CLIP P/N: MM670-35192-001. REF CRJ900 SRM 51-42-006-001-001-A01. DWG MM670-35012 REV GSDR REXA2022071301566Floorbeam · corrodedTHE AFT BAG BAY DOOR SURROUND LOWER SILL HAS MULTIPLE LOCATION OF CORROSION. REMOVED AND REPLACED AFT CARGO DOOR SILL. ASSY REF DWG MM670-35085 REV L. CRJ900 SRM 51-42-06-001-001-A01, CRJ900 SRM 51-42-21-001-001-A01.SDR REXA2022071301565Fitting · chafedTHE PAX DOOR SURROUND AFT ANCHOR FITTING IS CHAFFED. INSTALLED A NEW PAX DOOR SURROUND LOWER AFT ANCHOR FITTING (SWIVEL-LEVER P/N CC670-31982-5) WITH NEW HARDWARE. REF CRJ900 AMM 52-11-17-400-803.SDR REXA2022071301564Fitting · chafedTHE PAX DOOR SURROUND LOWER FWD ANCHOR FITTING IS CHAFFED. INSTALLED A NEW PAX DOOR SURROUND LOWER FWD ANCHOR FITTING (SWIVEL-LEVER P/N CC670-31982-6) WITH NEW HARDWARE. REF CRJ900 AMM 52-11-17-400-803-A01SDR REXA2022071301563Fitting · chafedTHE PAX DOOR SURROUND LOWER FWD PIN STOP FITTING IS CHAFFED. REPLACED PAX DOOR SURROUND LOWER-FORWARD STOP FITTING WITH NEW PN:601R38388-7. REF. CRJ900 AMM 52-11-02-400-830-A01SDR REXA2022071301562Fitting · chafedTHE PAX DOOR SURROUND LOWER AFT PIN STOP FITTING IS CHAFFED. INSTALLED NEW PAX DOOR SURROUND AFT PIN STOP FITTING REF CRJ900 AMM 52-11-02-400-830-A01.SDR REXA2022071301561Fitting · chafedTHE PAX DOOR SURROUND AFT LATCH FITTING IS CHAFFED. REMOVED AND INSTALLED NEW SERVICEBLE PAX DOOR AFT UPPER PIN STOP FITTING. REF. CRJ900 AMM 52-11-02-000-830-A01SDR REXA2022071301560Fitting · chafedTHE PAX DOOR SURROUND AFT CAM FITTING IS CHAFFED. INSTALLED NEW PAX DOOR SURROUND AFT CAM FITTING REF CRJ900 SRM 51-42-21-001-001-A01SDR REXA2022071301559Fitting · chafedTHE PAX DOOR SURROUND FWD CAM FITTING IS CHAFFED. INSTALLED NEW PAX DOOR SURROUND FWD CAM FITTING IAW CRJ900 SRM 51-42-21-001-001-A01.SDR REXA2022071301558Fitting · chafedTHE PAX DOOR SURROUND UPPER FWD STOP FITTING IS CHAFED. INSTALLED NEW PAX DOOR SURROUND FWD DROP DOWN STOP ASSY FITTING REF CRJ900 SRM 51-41-02-001-001-A01SDR REXA2022071301557Panel · chafedPANEL 584ET IS CHAFED. RECEIVED LOCATED AND DRILLED NEW PANEL ASSY, VANE ACCESS, FLAP INBD. PN#CC670-140027-3. REF CRJ900 SRM 51-40-11-001-001-A01.SDR REXA2022071301556Angle · crackedPASSENGER DOOR SUSPECTED AFT DRAG ANGLE CRACKED BY THE MOTOR ASSIST PULLEY. INSTALLED NEW DRAG ANGLE REPAIR SECTION AND 2 EA SPLICE ANGLES TO PAX DOOR AFT WEB DRAG ANGLE REF CRJ900 SRM 52-11-04-201-001-A01 REPAIR TYPE 1SDR REXA2022071301555Panel · damagedLEADING EDGE SKIN ON PANEL 622CB HAS DAMAGE. EVALUATED DAMAGED PANE #622CB. SUBMITTED TO ENGINEERING AND RECEIVED COMPLIED WITH ALL STEPS OF EA CRJ-957-13325 REV A 4-30-2022SDR REXA2022071301554Panel · chafedDAMAGE PANEL 699AB, CHAFE (IS MARKED). BLENDED CHAFE DAMAGE FROM PANEL 699AB REF CRJ900 SRM 51-12-00-001-001-A01. FOUND TO BE OUT OF LIMITS REF CRJ900 SRM 57-61-01-001-001-A01 AND CRJ900 SRM 57-61-01-101-001-A01. DRILL AND LOCATED NEW 699AB PANEL REF 900 SRM 5SDR REXA2022071301552Floor Support · crackedAFT SIDE OF BULKHEAD FS 1098.20 AT STRG 24L CLIP HAS THE APPEARANCE OF A CRACK. REPLACE CLIP IAW DWG MM670-35012 REV G. LOCATED AND DRILLED NEW CLIP IAW CRJ900 SRM 51-40-11-001-001-A01SDR REXA2022071301550Angle · crackedFS280 ANGLES AT RBL 7.0 POSSIBLE CRACK LOCATED, DRILLED AND REPLACED 2 EA ANGLES IAW BOMBARDIER DWG #CC670-34010 REV JSDR REXA2022071301549Floor Support · corrodedTHE AFT BAY DOOR SURROUND LOWER SILL HAS MULTIPLE LOCATIONS ON CORROSION REPLACED AFT DOOR SILL IAW DWG MM670-35085 REV LSDR REXA2022071301553Stringer · corrodedSTRINGER 21R AT APPROX FS969.00 IS CORRODED. REPAIRED STRINGER 21R BETWEEN FS942.00 AND FS927.00 REF CRJ900 ENDEAVOR AIR EA NO. CRJ953-13581 REV A DATED 6/7/22. PRESSURE LEAK CHECK GOOD.SDR REXA2022070101450Charger · inoperativeBATTERY CHARGER AND BATTERY PACK #4 FAIL OPERATIONAL TEST OF THE EMERGENCY LIGHTS. REMOVED AND INSTALLED NEW EPSU BATTERY PACK AND BATTERY CHARGER REF CRJ900 AMM 33-51-17-400-801-A02. OP TESTS GOOD.SDR REXA2022071301551Fitting · crackedLH FWD OVERWING PSGR EMERENCY EXIT DOOR HAS A SUSPENDED CRACK IN THE CAST BODY AT THE BASE OF ONE HOOK FITTING. CUT AND REMOVE DAMAGE AND INSTALL REPAIR DOUBLER AND FITTING.SDR REXA2021032900187Bulb · inoperativeL FWD E LIGHT BULB OUT ON EXTERIOR. DEFERRED L FWD E LIGHT BULB ON EXTERIOR IAW MEL 33-51-2A MOC NOTIFIED 96365 PLACARD INSTALLED MM02 UPDATED///R&R LIGHT BULB IN THE EXTERIOR EMERGENCY LIGHT IAW CRJ 900 AMM 33-51-15 OPS TEST GOOD MM02 UPDATED, PLACARD REMOVEDSDR REXA2019091601382Guide · bentPART RACKS: BENT ON METALIC GUIDES AT AFT CORE COWLING OF RT ENGINE. SUMMARY, METALIC GUIDES AT AFT CORE COWLING OF RT ENGINE WERE REPLACED PER SRM 51-41-02-001-001-A01. ADDITIONAL PART NUMBER REPLACED CN625-2379-008.SDR REXA2019091301387Striker · corrodedINITIAL INSPECTION: CORROSION ON LOWER SILL STRIKER OF GALLEY SERVICE DOOR SURROUND STRUCTURE. (PTAS)(TCI: 53-20-219). SUMMARY. CORROSION LEVEL 2, ON LOWER SILL STRIKER OF GALLEY SERVICE DOOR SURROUND STRUCTURE WAS REPLACED PER SRM 51-42-06-001-001-A01.SDR REXA2019091301383Support · corrodedINITIAL INSPECTION : CORROSION ON ANGLE SUPPORT CRAWLWAY FLOOR PANELS AT MAIN AVIONICS COMPARTMENT (E/E) (TCI: 53-10-219).
SUMMARY. CORROSION LEVEL 2. ANGLE SUPPORT CRAWLWAY FLOOR PANELS AT MAIN AVIONICS COMPARTMENT (E/E) WAS REPLACED PER SRM 51-42-06-001-00SDR REXA2019091301380Scuff Plate · dentedINITIAL INSPECTION: DENT ON SCUFF PLATE OF SOURROUND STRUCTURE AT THE FWD BAGGAGE BAY DOORS (CCD). SCUFF PLATE FWD BAGGAGE BAY DOORS WERE REPLACED PER AMM 25-52-01.SDR REXA2019091301379Retainer · brokenINITIAL INSPECTION. BROKEN AND BENT ON LOWER PRESSURE SEAL RETAINER IN FWD/AFT CORNER AT CENTRAL BAGGAGE BAY DOOR. (CCD)
SUMMARY. LOWER PRESSURE SEAL RETAINER WAS REPLACED PER SRM 51-42-06-001-001-A01 PAR. 6A UPPER PRESSURE RETAINER AND PRESSURE SEAL WILL BESDR REXA2019090801381Skin · wornINITIAL INSPECTION; WEAR ON PRESSURE BOX SKIN AT LOW PRESSURE GROUND AIR CONECTION. (FUS) SUMMARY: REPAIR PLATE WAS REPLACED PER EA NR CRJ953-09612,REV IR.SDR REXA2019090701384Floor Support · corrodedINITIAL INSPECTION: CORROSION ON FLOOR SUPPORT STA FS. 280 BTW LBL9 AND RBL9 AT COCKPIT (TCI: 53-10-219). CORROSION LEVEL 2. FLOOR SUPPORT STA FS 280 BTW LBL9 AND RBL9 AT COCKPIT WAS REPLACED PER SRM 51-42-06-001-001-A01 PAR 6A AND SRM 51-42-20-001-001-A01 PARSDR REXA2019090601389Support Angle · corrodedINITIAL INSPECTION: CORROSION ON SCUFFT PLATE ANGLE SUPPORTS (4EA) AT GALLEY SERVICE DOOR LOWER SURROUND STRUCTURE. (PTAS)(TCI:53-20-19). SUMMARY: ANGLE SUPPORTS (2EA) IN FS:319 AND FS:333 WERE REPLACED PER SRM 51-42-06-001-001-A01 PAR 6A AND CORROSION ON ANGLSDR REXA2019090501388Crossbeam · crackedAWR; HIDDEN DAMAGE: CRACK ON CROSSBEAM FS 280 RBL 14 IN REF NRC 252, TCI: 53-10-219 (CPAX). CROSSBEAM FS 280 RT REPLACED PER SRM 51-42-06-001-001-A01 PAR 6A, SRM 51-42-10-001-001-A01 PAR 8A. AND SRM 51-42-20-001-001-A01 PAR 6A.SDR REXA2019090501386Angle · corrodedINITIAL INSPECTION: CORROSION ON MOUNTING ANGLE AT LOWER SERVICE DOOR SURROUND STRUCTURE. (TCI 53-20-219). (PTAS). SUMMARY: MOUNTING ANGLE AT LOWER SERVICE DOOR SURROUND STRUCTURE WAS REPLACED SRM 51-42-06-001-001-A01.SDR REXA2019092001385Crossbeam · crackedAWR; HIDDEN DAMAGE: CRACK ON CROSSBEAM FS 280 LBL14 IN REF NRC 252, TCI: 53-10-219 (CPAX). CROSSBEAM FS 280 LT WAS REPLACED PER SRM 51-42-06-001-001-A01 PAR 6A, SRM 51-42-10-001-001-A01 PAR 8A AND SRM 51-42-20-001-001-A01 PAR 6A.SDR REXA2019080861175Connector · unsecureNOTED CABIN EMERGENCY LIGHT CEILING LEVEL ROW 1 INOPERATIVE. FOUND CONNECTOR FOR ROW 1 EMERGENCY LIGHT LOOSE. CONNECTED. PERFORMED OPS TEST OF EMERGENCY LIGHTS ALL NORMAL IAW AMM 33-51.SDR REXA2019071601127Hinge · damagedWHILE INCORPORATING SB 670BA-57-020 FOUND 1 FASTENER HOLE IN THE RT MAIN LANDING GEAR AFT DOOR HINGE AFT HOLE TO BE OVERSIZED TO .4355. REPAIRED RT MAIN LANDING GEAR AFT DOOR HINGE AFT FASTENER HOLE IAW REO 690-57-21-307.SDR REXA2018041000259Flashlight · inoperativeFWD FA FLASHLIGHT SEAL BROKEN AND THE FLASHLIGHT NOT CHARGING. REMOVED & REPLACED THE FWD FA FLASHLIGHT & SEAL IAW AMM 25-61-02 OPS CHECKED GOOD.SDR REXA2018031500192Oxygen Mask · missingFWD FA POB MISSING FACE MASKS. REPLACED TWO O2 BOTTLE MASK IAW AMM 35-31-04.SDR REXA2017112401196Smoke Detector · false activationFWD LAVATORY SMOKE ALARM ACTIVATED DURING PREVIOUS FLIGHT, POWERED DOWN AIRCRAFT PERFORMED AN OPS CHECK OF THE FWD LAVATORY SMOKE DETECTOR IAW AMM 26-16-00, NO DEFECTS NOTED. OK FOR SERVICE.SDR REXA2017101201092Oxygen Mask · failedFIRST OFFICER`S OXYGEN MASK FAILED A PRE-FLIGHT CHECK. R & R THE OXYGEN MASK IAW AMM 35-11-12, OPS CHECKED GOOD.SDR REXA2017090300968Pbe · damagedAFT PBE HAS NO VACUUM. REMOVED AND REPLACED THE PBE IAW AMM 35-31-06.
Back to N909XJ