N614QX
Service difficulty reports · 465
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 = 'N614QX' 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 = 'N614QX' 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 QXEA200500817Beam · gougedYYC - LEFT PYLON HINGE BEAM AT PYLON TIE BAR HAS GOUGES ON HINGE, TOP AND LOWER LOCATION FROM TIE BAR BRACKETS RUBBING. REPAIRED IAW CRJ700 MM 78-36-05-000-801-A01, PAGE 402, PARAGRAPH C, STEPS 1-4, REO 670-78-34-360 AND CRJ700 SRM 51-25-06-001-001-A01.SDR QXEA200500807Skin · nickedYYC - AFT BAGGAGE BAY DOOR HAS SCRATCHES AND NICKS ON TOP SURFACE OF OUTER SKIN. REPAIRED IAW CRJ700 SRM 52-31-01-101-001-A01, SRM 51-12-00-001-001-A01 AND SRM 51-25-01-001-001-A01.SDR QXEA200500818Cowling · chafedYYC - RIGHT ENGINE, UPPER COWLING AREA, TRANSCOWL ASSEMBLY, FOUR EACH RETAINERS ARE CHAFING ON THE TORQUE BOX ASSEMBLY. REPAIRED IAW HORIZON AIR EA R-78-42 AND REO 670-78-34-361.SDR QXEA200500827Door · chafedYYC - RIGHT ENGINE, TRANS COWL LATCH DOOR ASSEMBLY, CHAFING ON TRANS COWL STRUCTURE AT AFT EDGE. REPAIRED IAW CRJ700 SRM 54-21-00-101-001-A01 AND SRM 51-25-01-001-001-A01.SDR QXEA200500820Retainer · chafedYYC - RT ENGINE, LOWER TRANSCOWLING HAS THREE RETAINERS THAT ARE CHAFING ON THE TORQUE BOX ASSEMBLY (4:00, 6:00 AND 8:00 O'CLOCK POSITIONS). REPAIRED IAW HORIZON AIR EA R-78-4 AND REO 670-78-34-361.SDR QXEA200500734Housing · gougedYYC - LT WING TRAILING EDGE OUTBOARD FLAP GUIDE ROLLER HOUSING GOUGED AT WING STATION 147.50. REPAIRED IAW CRJ700 SRM 57-51-02-201-001-A01 AND 51-24-11-001-001-A01.SDR QXEA200500822Beam · nickedYYC - RIGHT PYLON, HINGE BEAM HAS NICK 6" FORWARD OF PYLON TIE BAR NR 3 HINGE POSITION. REPAIRED IAW HORIZON AIR EA R-78-36 AND REO 670-78-34-260.SDR QXEA200500804Skin · scratchedYYC - FUSELAGE UPPER SKIN AT STATION 300 AND STRINGER 0 HAS SCRATCHES UNDER TCAS ANTENNA. REPAIRED IAW CRJ700 SRM 51-12-00, SRM 51-21-11-001-001-A01, REO 670-53-21-099, HORIZON AIR EA R-53-314SDR QXEA200500810Cowling · wornYYC - LEFT ENGINE, THRUST REVERSER, TRANSLATING UPPER COWL, INBOARD "TR CLOSED" RAMPS AND STARTERS ARE WORN. REPAIRED IAW HORIZON AIR EA R-78-41, REO 670-78-34-361.SDR QXEA200500828Door · wornYYC - RIGHT ENGINE TRANS COWL LATCH DOOR ASSEMBLY AREA, DOOR LATCH CONTACT POINT WORN. REPLACED IAW CRJ700 SRM 51-42-06-001-001-A01.SDR QXEA200500780Skin Panel · damagedYYC - FORWARD FUSELAGE, FORWARD LOWER SKIN PANEL HAS ROCK CHIP PITTING DAMAGE AT STATION 295 TO 310 BETWEEN STRINGER 25R AND STRINGER 26L. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01, 53-21-01-101-002-A01, 51-12-00-001-001-A01, AND 51-25-01-001-001-A01.SDR QXEA200500788Attach Fitting · damagedYYC - FORWARD BAGGAGE DOOR AFT TOP LUG FOR ROLLER ATTACH TO COUNTER BALANCE HAS NICKS AND SCRATCHES. REPAIRED IAW CRJ700 SRM 52-35-06-101-001-A01, 51-12-00-001-001-A01, AND 51-25-01-001-001-A01.SDR QXEA200500776Skin · gougedYYC-RIGHT NACELLE LIP SKIN HAS GOUGES BETWEEN 3 AND 5 O'CLOCK POSITION. REPAIRED IAW CRJ700 SRM 51-12-00-001-001-A01, 54-11-05-101-001-A01, AND 51-21-11-001-001-A01.SDR QXEA200500774Skin Panel · damagedYYC - FORWARD FUSELAGE, FORWARD LOWER SKIN PANEL HAS ROCK CHIP PITTING DAMAGE AT STATION 349 TO 379 BETWEEN STRINGER 24R AND STRINGER 23L. REPAIRED IAW HORIZON AIR EA R-53-311 AND REO 670-53-21-097.SDR QXEA200500773Skin Panel · chafedYYC - FORWARD FUSELAGE, FORWARD LOWER SKIN PANEL CHAFING DAMAGE BY POTABLE WATER SERVICE DOOR STATION 349 TO 364 BETWEEN STRINGER 21R AND STRINGER 24R. REPAIRED IAW HORIZON AIR EA R-53-312 AND REO 670-53-21-095.SDR QXEA200500759Skin · chafedYYC- LEFT INBOARD FLAP LOWER EXTERNAL SURFACE HAS CHAFE MARKS UNDER INBOARD HINGE ARM FAIRING. REPAIRED IAW CRJ700 SRM 51-12-00-001-001-A01, 57-52-01-101-001-A01, AND 51-25-01-001-001-A01.SDR QXEA200500730Skin · damagedYYC - LT INBOARD FLAP LOWER SKIN HAS GRAVEL DAMAGE. REPAIRED IAW HORIZON AIR EA R-57-113, REO 670-57-52-024 AND CRJ700 SRM 51-25-101-001-001-A01.SDR QXEA200500793Bulkhead · corrodedYYC - FUSELAGE INTERIOR, LEFT LOWER WEB OF FUSELAGE STATION 280 BULKHEAD IS CORRODED ALONG THE FLOOR LINE. REPAIRED IAW REO 670-53-11-052, REV A.SDR QXEA200500795Floor Support · corrodedYYC - FUSELAGE INTERIOR, COCKPIT FLOOR PANEL SUPPORT ANGLE IS CORRODED. REPLACED IAW CRJ700 SRM 51-42-06-001-001-A01.SDR QXEA200500794Bulkhead · corrodedYYC - FUSELAGE INTERIOR, RIGHT LOWER WEB OF FUSELAGE STATION 280 BULKHEAD IS CORRODED ALONG THE FLOOR LINE. REPAIRED IAW REO 670-53-11-052, REV A.SDR QXEA200500800Skin · nickedYYC - FUSELAGE EXTERIOR HAS AREAS OF NICKS ABOVE AFT CARGO DOOR AT STATION 1031 ON FUSELAGE SKIN. REPAIRED IAW HORIZON AIR EA R-53-315, REO 670-53-61-166, CRJ700 SRM 51-25-01-001-001-A01 AND SRM 51-21-16-001-001-A01.SDR QXEA200500799Skin · scratchedYYC - FUSELAGE EXTERIOR HAS SCRATCHES AT STATION 310 AND STRINGER 13L. REPAIRED IAW CRJ700 SRM 53-21-01-101-001-A01, SRM 51-12-00-001-001-A01 AND SRM 51-25-01-001-001-A01.SDR QXEA200500798Sill · corrodedYYC - AFT BAGGAGE BAY DOOR STRUCTURE SURROUND HAS FRETTING DAMAGE ON LOWER SILL PLATE AND PAINT/PRIMMER MISSING. REPAIRED IAW CRJ700 SRM 51-12-00-001-001-A01, SRM 51-21-11-001-001-A01 AND SRM 51-25-01-001-001-A01.SDR QXEA200500792Floorbeam · corrodedYYC - FUSELAGE INTERIOR, FUSELAGE STATION 280 FLOOR SUPPORT CROSSBEAM IS CORRODED ON TOP FLANGE FROM LBL30 TO RBL30. REPAIRED IAW REO 670-53-11-047.SDR QXEA200500796Fitting · corrodedYYC - RIGHT OUTBOARD FLAP INBOARD ROLLER FITTING HAS FRETTING CORROSION. REPAIRED IAW REO 670-57-53-015, SRM 51-25-16-001-001-A010 AND SRM 51-24-11.SDR QXEA200500791Skin · damagedYYC - RIGHT INBOARD FLAP LOWER SKIN HAS GRAVEL DAMAGE. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01 AND SRM 51-25-01-001-001-A01.SDR QXEA200500823Hinge · gougedYYC - RIGHT PYLON HINGE BEAM AT PYLON TIE BAR HAS GOUGES ON HINGE TOP AND LOWER LOCATIONS FROM TIE BAR BRACKETS RUBBING NR 3 HINGE POSITION. REPAIRED IAW REO 670-78-34-360 AND HORIZON AIR EA R-78-36.SDR QXEA200500809Skin · damagedYYC - FORWARD FUSELAGE BELOW FORWARD BAGGAGE BAY OPENING AT STATION 517.00 BETWEEN STRINGER 25L AND 26L ROCK CHIP IN SKIN PANEL. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01, SRM 53-31-01-101-003-A01 AND SRM 51-25-01-001-001-A01.SDR QXEA200500778Skin · damagedYYC-RIGHT PYLON, TOP SIDE, CENTER SECTION MISSING AREA OF PAINT. REPAIRED IAW CRJ700 SRM 51-25-01-001-001-A01.SDR QXEA200500777Skin · gougedYYC - LEFT NACELLE LIPSKIN HAS GOUGES BETWEEN 6 AND 8 O'CLOCK POSITION. REPAIRED IAW CRJ700 SRM 51-12-00-001-001-A01, 54-11-08-101-001-A01, AND 51-21-11-001-001-A01.SDR QXEA200500775Skin Panel · damagedYYC - FORWARD FUSELAGE, FORWARD LOWER SKIN PANEL HAS ROCK CHIP PITTING DAMAGE AT STATION 333 TO 349 BETWEEN STRINGER 25R AND STRINGER 26R. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01, 53-21-01-101-006-A01, 51-12-00-001-001-A01, AND 51-25-01-001-001-A01.SDR QXEA200500771Skin Panel · damagedYYC - FORWARD FUSELAGE, FORWARD LOWER SKIN PANEL HAS ROCK CHIP PITTING DAMAGE, STATION 421 TO 437, BETWEEN STRINGER 26R AND STRINGER 27C AND STRINGER 23L AND 22L. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01, 53-21-01-101-006-A01, 51-12-00-001-001-A01, AND 51SDR QXEA200500772Skin Panel · damagedYYC - FORWARD FUSELAGE, FORWARD LOWER SKIN PANEL HAS ROCK CHIP PITTING DAMAGE AT STATION 394 TO 409 BETWEEN STRINGER 24R AND STRINGER 25L. REPAIRED IAW REO 670-53-21-096, AND HORIZON AIR EA R-53-309.SDR QXEA200500779Skin Panel · damagedYYC - FORWARD FUSELAGE, FORWARD FUSELAGE LOWER SKIN PANEL HAS ROCK CHIP PITTING DAMAGE AT STATION 319.70 TO 333 BETWEEN STRINGER 26R AND STRINGER 25R. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01, 53-21-01-101-002-A01, AND 51-25-01-001-001-A01.SDR QXEA200500757Skin · damagedYYC - FORWARD FUSELAGE, FORWARD LOWER SKIN PANEL ROCK CHIP PITTING DAMAGE FS 437 TO 453 BETWEEN STRINGER 25R AND 25L. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01, 51-12-00-001-001-A01, AND 53-21-01-101-006-A01.SDR QXEA200500756Skin · damagedYYC - FORWARD FUSELAGE, FORWARD LOWER SKIN PANEL FS 469 TO 477 BETWEEN STRINGER 24L AND 25L ROCK CHIP PITTING DAMAGE. REPAIRED IAW REO 670-53-21-094 AND HORIZON AIR EA R-53-308.SDR QXEA200500752Structure · chafedYYC - LOWER FUSELAGE IN WHEEL WELL HAS LOOSE DIAPHRAGM AT UPPER ATTACH SCREWS AND CHAFING DAMAGE. REPAIRED IAW CRJ700 SRM 51-42-001-001-A01, SRM 51-42-06-001-001-A01, AND SRM 51-42-21-001-001-A01.SDR QXEA200500755Skin · corrodedYYC - FORWARD FUSELAGE, BELOW FORWARD BAGGAGE BAY OPENING FS 581 TO FS 594 BETWEEN STRINGER 27R AND STRINGER 26R ROCK CHIP PITTING IN SKIN PANEL. REPAIRED IAW CRJ700 SRM 53-31-01-101-003-A01, 51-12-00-001-001-A01, 51-25-16-001-001-A01, AND 51-25-01-001-001-A0SDR QXEA200500754Skin · corrodedYYC - FORWARD FUSELAGE, BELOW FORWARD BAGGAGE BAY OPENING FS 565 TO FS 581, BETWEEN STRINGER 26L AND STRINGER 27L ROCK CHIP PITTING IN SKIN PANEL. REPAIRED IAW CRJ700 SRM 53-31-01-101-003-A01, 51-25-16-001-001-A01, AND 51-25-01-001-001-A01.SDR QXEA200500753Striker · wornYYC - LEFT HAND ENGINE, CORE COWL LOWER, BELOW OF DOOR LATCH STRIKER PLATE IS WORN. REPAIRED IAW CRJ700 SRM 51-24-16-001-001-A01, 51-42-06-001-001-A01, AND 51-42-13-001-001-A01.SDR QXEA200500731Fastener · looseYYC - LEFTHAND WING UPPER SKIN TRAILING EDGE, INBOARD OF INBOARD MULTI SPOILER HAS LOOSE FASTENERS. REPAIRED IAW CRJ700 SRM 51-62-06-001-001-A01.SDR QXEA200500733Fitting · corrodedYYC - RIGHTHAND OUTBOARD FLAP INBOARD ROLLER FITTING HAS FRETTING CORROSION. REPAIRED IAW REO 670-57-53-015 AND CRJ700 SRM 51-25-16-001-001-A01.SDR QXEA200500732Fastener · brokenYYC - LEFTHAND WING UPPER SKIN, TRAILING EDGE, OUTBOARD SIDE OF OUTBOARD MULTI SPOILER HAS TWO BROKEN FASTENERS. REPLACED IAW CRJ700 SRM 51-62-06-001-001-A01.SDR QXEA200500737Skin · tool damageYYC - FORWARD FUSELAGE LOWER SKIN PANEL TOOLING DAMAGE TO THE LOWER SKIN AT FUSELAGE STATION 549.00 AND 565.00 BETWEEN STRINGER 24R AND 25R. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01, SRM 53-31-01-101-003-A01 AND SRM 51-25-01-001-001-A01.SDR QXEA200500748Skin · gougedYYC - LOWER FUSELAGE SKIN AT STATION 981 AND STRINGER 27 HAS TWO GOUGES. REPAIRED IAW CRJ700 SRM 51-42-21-001-001-A01 AND HORIZON AIR EA R-53-307.SDR QXEA200500735Skin · damagedYYC - FORWARD FUSELAGE - BELOW FORWARD BAGGAGE BAY OPENING FUSELAGE STATION 549.00 TO 533.00 BETWEEN STRINGER 25L AND 25R ROCK CHIP PITTING. REPAIRED IAW CRJ700 SRM 51-26-00-001-001-A01, SRM 51-25-01-001-001-A01 AND SRM 53-31-01-101-003-A01.SDR QXEA200500736Stringer · chafedYYC - FORWARD FUSELAGE - FORWARD BAGGAGE BAY OPENING FUSELAGE STATION 565.00 TO 533.0 EDGE OF LOWER DOOR OPENING CUTOUT CHAFED AT STRINGER 25L. REPAIRED IAW REO 670-53-31-036, HORIZON AIR EA R-53-305 AND CRJ700 SRM 51-25-01-001-001-A01.SDR QXEA200500808Skin · gougedYYC - AFT FUSELAGE SKIN GOUGED AT STATION 5.00 BETWEEN STRINGER 26R AND 25R. REPAIRED IAW CRJ700/900 SRM 51-12-00-001-001-A01, 53-00-01-101-001-A01 AND CRJ700 SRM 51-25-01-001-001-A01.SDR QXEA200500801Skin · nickedYYC - FUSELAGE EXTERIOR SKIN AT STATION 1000, BETWEEN STRINGER 14L AND 15L HAS NICK ON SKIN. REPAIRED IAW HORIZON AIR EA R-53-306, REO 670-53-61-165 AND CRJ700 SRM 51-25-01-001-001-A01.SDR QXEA200500803Skin · nickedYYC - FUSELAGE EXTERIOR HAS NICK AT STATION 823 BELOW STINGER 15R. REPAIRED IAW HORIZON AIR EA R-53-301, REO 670-53-41-013 AND CRJ700 SRM 51-25-01-001-001-A01.
Back to N614QX