N921FJ
Service difficulty reports · 330
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 = 'N921FJ' 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 = 'N921FJ' 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 MASA2012022134469Crossbeam · corrodedFS 280.00 BULKHEAD WEB HAS CORROSION OUT OF LIMITS AT RBL 10 AND RBL 20 WL 73. REMOVED AND REPLACED CROSSBEAM AND WEB IAW SRM 51-42-13-001-001, 51-42-06-001-001, 51-42-21-001-001.SDR MASA2012022134468Crossbeam · corrodedFS 280.00 CROSSBEAM HAS MINOR CORROSION ON TOP OF BEAM AT LBL 9. REMOVED CORROSION IAW EO CL600-2D24-53-L00952.SDR MASA2012022134467Striker · dentedPAX DOOR AFT SEAL STRIKER IS DENTED AT FS 349 UPPER SECTION. REPAIRED STRIKER IAW REO 670-53-22-001. REPAIR TYPE 1.SDR MASA2012022034452Seat Track · corrodedSEAT TRACK AT FS 477.40 TO 693.00, LBL 9.0 HAS AREAS OF LIGHT CORROSION. REMOVED CORROSION FROM CABIN FLOOR SEAT TRACK IAW REO 670-53-00-013 REV E.SDR MASA2011122964314Seal · brokenEMK SEAL BROKEN. INSPECTED & RE-SEALED.SDR MASA2011122664280Battery · inoperativeFWD CABIN FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED BATTERIESSDR MASA2011122234269Battery · inoperativeFWD F/A FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED BATTERIES.SDR MASA2011122764288Battery · dischargedFWD CABIN FLASHLIGHT INOP. REMOVED AND REPLACED FLASHLIGHT BATTERIES. OPS CHECK IS GOOD.SDR MASA2011122264246Light · inoperativeNR 6 CEILING EMERGENCY FLOOD LIGHT INOP. REPLACED LAMP IN NR 6 CEILING EMERGENCY FLOOD LIGHT.SDR MASA2011122064239Light · inoperativeNR 6 CEILING EMERGENCY FLOOD LIGHT INOP. R2 LAMP IN NR 6 CEILING EMERGENCY FLOOD LIGHT.SDR MASA2011121364218Door · out of adjustUNABLE TO CLOSE FWD SERVICE DOOR. ADJUSTED DOOR.SDR MASA2011121364213Structure · dentedFIVE DENTS LOCATED ON RT WING L/E SLAT BETWEEN SS58-75-SS92.00 OUT OF LIMITS. C/W RO CRJ9-57-0344.SDR MASA2011121364212Skin · damagedHORIZONTAL STABLIZER WAS REMOVED TO FACILITATE MAINTENANCE WHILE BEING SUPPORTED ONE OF THE SAWHORSES BEING USED HAD PROTRUDING HARDWARE WHICH CAUSED DAMAGE TO LEADING EDGE. C/W RO CRJ9-55-0144.SDR MASA2011121364211Skin · dentedUPPER RT HORIZONTAL STAB WAS FOUND TO HAVE MULTIPLE DENTS DUE TO HAIL STORM. C/W RO CRJ9-55-0140.SDR MASA2011121364210Skin · dentedLT UPPER HORIZONTAL STABLIZER WAS FOUND TO HAVE MULTIPLE OUT OF LIMITS DENTS DUE TO HAIL STORM. C/W RO CRJ9-55-0141.SDR MASA2011121364209Structure · dentedAFT CENTER FUSELAGE SUSTAINED 2 OUT OF LIMITS DENTS AT FS 897-7-FS 969.00 BETWEEN STR 4L-STR 7L. C/W RO CRJ9-53-0772.SDR MASA2011121364208Structure · dentedDENT LOCATED AT FS 1000-1015 BETWEEN STR 7L-8L OUT OF LIMITS. C/W RO CRJ9-53-0780.SDR MASA2011121364207Skin · dentedSINGLE OUT OF LIMIT DENT LOCATED ON AFT LT FUSELAGE CENTER UPPER SKIN AT FS 942.00-FS 969.00 BETWEEN STR 0-3R. C/W RO CRJ9-53-0781.SDR MASA2011121364206Skin · dentedSINGLE OUT OF LIMIT DENT LOCATED ON FORWARD LT FUSELAGE AT FS 235.00 BETWEEN STR 12L-STR 13L, OUT OF LIMITS DUE TO HAIL DAMAGE. C/W RO CRJ9-53-0813.SDR MASA2011121364205Skin · dentedAIRCRAFT HAD MULITPLE OUT OF LIMITS DENTS ON AFT CROWN OF THE FUSELAGE BETWEEN FS 977-FS 1162, STR 7L-STR 7R DUE TO HAIL STORM. C/W REO690-53-61-206.SDR MASA2011121364202Slat · dentedONE OUT OF LIMIT DENT ON NR 1 LHS. PERMANENT REPAIR FOR 1 OFF DENT ON NR 1 LHS SLAT BETWEEN SS82.00 & SS92.20. C/W RO CRJ9-57-0328, TASK MRO 18142.SDR MASA2011121364201Frame · damagedONE DAMAGE HOLE IN UPPER FRAME SECTION AT FS 409.00 AND ANGLE VHF ANTENNA, RT LOWER HOLE. DISCREPANT HOLE OPENED TO.216 C/W RO CRJ9-53-0811, TASK MRO 18321.SDR MASA2011121364200Structure · dentedMULTIPLE DENTS LOCATED AT FS 295.00-331.00 STR 05RT. C/W RO CRJ9-53-0812, TASK MRO 18322.SDR MASA2011121364199Skin · defectiveFOUR REDUNDANT HOLES FOUND IN REPLACEMENT SKIN PANEL P/N SH670-330013-13 LOCATED AT FS 506.125 BETWEEN STR 5L-6L(2) AND STR 5R-6R(2). C/W RO CRJ9-53-0830, TASK MRO 18396.SDR MASA2011121364198Stringer · damagedMULTIPLE DOUBLE DRILLED HOLES IN STR 1R BETWEEN FS 333-FS 477. C/W RO CRJ9-53-0832, TASK MRO 18406.SDR MASA2011121364197Stringer · damagedMULTIPLE DENTS DRILLED HOLES ON STR 1R BETWEEN FS 453-FS 469. C/W RO CRJ9-53-0833, TASK MRO 18406.SDR MASA2011121364204Slat · dentedONE OUT OF LIMIT DENT ON NR 2 RHS. PERMANENT REPAIR FOR 1 OFF DENT ON NR 2 RHS BETWEEN SS315.75 &TRACK 2-3. C/W RO CRJ9-57-0330, TASK MRO 18134.SDR MASA2011121364203Slat · dentedONE OUT OF LIMIT DENT ON NR 3 LHS. PERMANENT REPAIR FOR 1 OFF DENT ON NR 3 LHS SLAT BETWEEN SS339.00 &TRACK 3-2. C/W RO CRJ9-57-0329, TASK MRO 18140.SDR MASA2011121364196Skin · dentedFOUR DENTS ON RT HORIZONTAL STAB LEADING EDGE. C/W RO 690-55-12-061.SDR MASA2011121364195Skin · dentedMULTIPLE DENTS FOUND ON LT FUSELAGE SKIN. C/W RO 690-53-00-182.SDR MASA2011121364194Skin · damagedFOUND DAMAGE TO FUSELAGE SKIN AT FS 196.25 BETWEEN STRINGERS 14L AND 16L IN RVSM AREA. C/W MESA RO# 690-53-11-339.SDR MASA2011121364193Frame · damagedFOUND DAMAGE TO FRAME OUTER FLANGE AT FS 409 STRINGERS 2 TO 3, LT. C/W RO 690-53-21-285.SDR MASA2011121364192Skin · damagedFOUND DAMAGE TO FUSELAGE SKIN AT FS 410 TO FS 418 BETWEEN STRINGERS 9L AND 13. C/W RO 690-53-21-292.SDR MASA2011121364191Skin · damagedFOUND DAMAGE TO FUSELAGE FWD BARREL SIDE SKIN AT FS 501 STRINGER 12L AND FS 661+74 STRINGER 13L. C/W MESA RO 690-53-31-104.SDR MASA2011121364190Skin · damagedFOUND DAMAGE TO CENTER FUSELAGE RT SKIN BETWEEN FS 708 AND FS 720.85 AT STRINGER 10R. C/W RO 690-53-41-031.SDR MASA2011121364189Skin · dentedTWO (2) DENTS ON LT APRON SKIN BETWEEN FS 801.25 AND FS 830.40. C/W RO 690-53-42-003.SDR MASA2011121364188Structure · dentedDENT AT FS 236 FOUND TO BE OUT OF LIMITS. C/W RO CRJ9-53-0776.SDR MASA2011121364187Skin Panel · damagedSPLICE REPAIR TO GALLEY DOOR OUTBOARD SKIN PANEL. C/W RO CRJ9-52-0460.SDR MASA2011121364186Skin · dentedDENTS AT CENTER FUSELAGE UPPER SKIN AT FS 942- FS 969, STINGER 0-3R. DAMAGE CAUSED BY WEATHER EVENT WHILE A/C WAS AT JETWAY REO 690-53-51-049 REV B. C/W RO CRJ9-53-0781.SDR MASA2011121364185Skin Panel · damagedDAMAGE FOUND TO LT EMERGENCY EXIT DOOR SKIN PANEL. C/W RO 690-52-21-008.SDR MASA2011080303383Light · inoperativeOVERHEAD EMERGENCY LIGHT ROW 20 INOP. RELAMPED EMERGENCY LIGHT.SDR MASA2011080103356Handle · unsecurePROX SYS FAULT 2. FOUND DOOR HANDLE INCORRECTLY STOWED, RESTOWED HANDLE.SDR MASA2011071803262Warning System · false activationPROX SYS 2 FAULT. CYCLED DOOR.SDR MASA2011071503237Oxygen Mask · brokenOBS O2 MASK BROKEN. O2 MASK PN:MC10-35-101 IN STOCK ALL STATIONS RONS IN CLT 7/18.SDR MASA2011071303212Computer · malfunctionedUNCOMMANDED SPD BUG CHANGE WITH AUTO PILOT ON CLIMB. PLACED ON MEL. RERACKED FCC 1 AND 2SDR MASA2011071203204Light · inoperativeFWD ENTRY FWD UPPER EMERGENCY LIGHT HAS 1 BULB OUT. RELAMPED EMERGENCY LIGHT.SDR MASA2011061603019Light · inoperativeSERVICE DOOR AFT EMERGENCY LIGHT BULB OUT. RELAMPED EMERGENCY LIGHT.SDR MASA2011053002890Light · inoperativeTHE 16A SIDE EMERGENCY LIGHT ASSY- 1 BULB OUT. RELAMPED 16A SIDEWALL EXIT SIGN.SDR MASA2011053002886Cable · frayedPAX DOOR ASSIST CABLE FRAYED. R2 CABLE.SDR MASA2011052702883Warning System · false activationLT ENG BLEED CAUTION AFTER TO. ENG BLEEDS OPS NORMAL NFAR.
Back to N921FJ