N664US, cancelled Jan 24, 2018
Service difficulty reports · 134
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 = 'N664US' AND deregistration_id = 'N664US-2018-01-24' 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 = 'N664US' AND deregistration_id = 'N664US-2018-01-24' 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 DALA2015041202750Connector · unsecureA/C 6304, DOOR 1 LT DOOR EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED FAIRING COVER, FOUND CONNECTOR PLUG DISCONNECTED; RECONNECTED CONNECTOR PLUG. OPS CHECKED GOOD IAW AMM 33-51. 6443060.SDR DALA2015032302455Lamp · inoperativeDOORS 1L AND 1R EMERGENCY ILLUMINATION LIGHTS INOPERATIVE. RELAMPED DOOR 1L; OPS CHECKED GOOD. DOOR 1R REQUIRED LIGHT ASSY REPLACEMENT.SDR DALA2015031502166Light · damagedEMERGENCY LIGHT DAMAGED SEAT 22H. INSTALLED NEW LIGHT ASSY.SDR DALA2014112406220Battery Pack · inoperativeUPPER DECK EMERGENCY EXIT SIGNS INOPERATIVE. R & R BATTERY PACK.SDR DALA2014112206218Battery Pack · dischargedUPPER DECK EMERGENCY LIGHTS, AISLE, GO DEAD SHORTLY AFTER TURNING ON. R & R M335 & M334 BATTERY PACKS.SDR DALA2014103105865Power Supply · inoperativeSEAT 77-79A, EMERGENCY LIGHT INOPERATIVE, REPLACED THE POWER SUPPLY.SDR DALA2014100905458Light · inoperativeEMERGENCY EXIT LIGHT ON L2 DOOR INOPERATIVE. R & R EMERGENCY SLIDE LIGHT ASSY.SDR DALA14026796304Stringer · corrodedCORROSION FOUND BS 220, STRINGER 42L. REPAIRED STRINGER IAW SRM 51-00-00, FIG 16 AND 23.SDR DALA14026786304Stringer · corrodedBILGE AREA STRINGER 48L FOUND CORRODED BS 2220-2240. INSTALLED NEW SECTION OF STRINGER IAW SRM 53-00-03, REPAIR 3.SDR DALA13072416304Battery Pack · inoperativeUPPER DECK LT EMERGENCY POWER RESERVOIR "BATTERY OK" LIGHT WON'T ILLUMINATE. REPLACED BATTERY, CHECKED OK IAW AMM 52-23.SDR DALA13052576304Light · inoperativeRT SECOND EXTERIOR EMERGENCY LIGHT FROM AFT INOPERATIVE. REPLACED OVER WING EMERGENCY LIGHT ASSY CHECKED NORMAL, AMM 33-51. OK FOR SERVICE.SDR DALA13025596304Battery Pack · inoperativeUPPER DECK FORWARD SECTION, ALL EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK AT DM0335.SDR DALA13016326304Light · inoperativeDOOR MOUNTED EMERGENCY LIGHTS AT 4R AND 5L INOPERATIVE. REPLACED EMERGENCY LIGHT ASSY AT DOOR 5L.SDR DALA13012386304Tension Tie · damagedHFEC OPEN HOLE INSPECTION, FOUND ONE HOLE DAMAGED ON BS 1200 TENSION TIE LT SIDE AFT C-CHANNEL. TENSION TIE REPAIRED IAW SRM 53-40-30, REPAIR 1.SDR DALA13012376304Tension Tie · damagedHFEC OPEN HOLE INSPECTION, FOUND HOLE DAMAGE ONE ON BS 1200 TENSION TIE RT SIDE AFT C-CHANNEL. TENSION TIE REPAIRED IAW SRM 53-40-30, REPAIR 1.SDR DALA12013686304Skin · damagedFOUND SKIN DAMAGED FWD OF L2 DOOR. DAMAGE APPROX 4.5 INCHES LONG, 2 INCHES HIGH. REPAIRED IAW ERA509057-14 AND ERA 509036-14.SDR DALA12013676304Panel · buckledFOUND SHEAR PANEL BUCKLED BS 720-740 S26L. REPAIRED IAW ERA 509057-14.SDR DALA12013666304Skin · dentedFOUND DENT IN SKIN, STR 27L AT SKIN ATTACH FLANGE. REPAIRED IAW ERA 509084-14.SDR DALA1224686304Stringer Fitting · damagedDURING HFEC OPEN HOLE INSP FOUND DAMAGE (01EA) ON END FTG AT STA 1000 STR 37R. MAINTENANCE REPLACED STRINGER END FITTING P/N: 65B10061-8 AS PER PRI501602-14AD REV 0.SDR DALA1223446304Fastener · damagedDURING INSPECTION FOUND 2 EXISTING FASTENERS THRU CHEMMILL FUSELAGE SKIN STA 400 BETWEEN STR 11R-12R. MAINTENANCE REMOVED EXISTING FASTENERS AND INSTALLED NEW FASTENERS PER PRI 501983-14.SDR DALA1222656304Skin · misrepairedDURING ACCOMPLISHING FUSELAGE SKIN BS 460 ABOVE DOOR 1L (INSP/MOD- SECTION 01A), FOUND FASTENER HOLES SHORT EDGE MARGIN CONDITION C/T FUSELAGE SKINS & STA 460 LT FRAME IF MODIFICATION CARRIED OUT PER DELTA DWG SA5331- 01145-13 & SRM. MAINTENANCE REPASDR DALA1222416304Pan · delaminatedDURING INSPECTION, MAIN DECK CABIN BULKHEAD BS 2360 AND BL OHST FUEL TRANSFER LINE BLEED AIR DUCT APU FUEL FEED LINE ATTACH FIBERGLASS PAN FOUND DELAMINATION. MAINTENANCE PERFORMED REPAIR PER PRI 501582-14 REV 1.SDR DALA1222376304Skin · corrodedDURING H-CHECK AT SASCO, DISCREPANCIES WERE NOTED DURING ACCOMPLISHMENT OF EM 5331-01145-01A AND -01B, ALONG WITH CORROSION ON THE BS 460 FRAME AND SOME ELONGATED HOLES. ER/A 500831-14AD SECTION I WAS ACCOMPLISHED.SDR DALA1222366304Skin · crackedDURING H-CHECK AT SASCO APR2012, CRACKS WERE FOUND AT THE UPPER FORWARD CORNER OF THE AFT CARGO CUTOUT. ER/A 501579-14AD SECTION I WAS ACCOMPLISHED. FOLLOW ON ACTION IS REQUIRED FOR SECTION II.SDR DALA1222116304Skin · crackedDURING H CHECK, CRACKS WERE FOUND AT THE L3 MAIN ENTRY DOOR, UPPER AFT CORNER. ER/A 501583-14AD SECTION I, WAS ACCOMPLISHED.SDR DALA1222086304Skin · crackedDURING H CHECK, CRACKS WERE FOUND AT THE R3 MAIN ENTRY DOOR, UPPER AFT CORNER. ER/A 501578-14AD SECTION I WAS ACCOMPLISHED.SDR DALA1222756304Frame · damagedHFEC OPEN HOLE INSPECTION FOUND HOLE DAMAGE 01EA ON BS 1220 TENSION TIE RIGHT SIDE AFT "C" CHANNEL. MAIN DECK CABIN BS 1220 RT TENSION TIE AFT CHANNEL HOLE DAMAGE REPAIRED AS PER SRM 53-40-30 REPAIR 1.SDR DALA1221506304Frame · crackedSTA 1255, BETWEEN S4R TO S5R FOUND ONE FRAME WEB CRACK. CRACKED WEB AT CABIN STA 1255 BETWEEN S4R TO S5R AREA REMOVED AS PER SRM 51-40-02 NEW WEB FABRICATED AS PER DWG 65B04913 REV E. NEW WEB AT STA 1255 BETWEEN S-4R TO S-5R AREA INSTALLED AS PER SRM 51-40-0SDR DALA1220036304Rib · crackedRT WING INTERSPAR RIB WS 1423 WEB FOUND CRACKED ALONG SEVERAL FASTENERS. REPAIRED PER SRM 57-20-09 FIG 201.SDR DALA1220116304Frame · damagedBS 460 FRAME FOUND DAMAGED. REPAIRED PER PRI 500831-14 REV. 2.SDR DALA1220016304Seat Track · corrodedMAIN DECK CABIN SEAT TRACK CROWN AT BS 575 AND RBL 91.67 FOUND CORRODED. CORRODED SEAT TRACK REMOVED AS PER SRM 51-40-02. NEW SEAT TRACK FABRICATED AS PER DWG 140U5282 REV A. NEW SEAT TRACK INSTALLED AS PER SRM 51-40-02.SDR DALA1224876304Structure · crackedDURING HFEC SURFACE INSPECTION ON AFT CARGO DOOR CUTOUT UPPER FORWARD CORNER, CRACK FOUND PROPAGATE FROM HOLE NR 2 TO THE EDGE APPROX 3/4" AS MARKED. WORK CARRIED OUT AS PER PRI 501579-14 REV 0 AND PRI 501579-14 REV 1 AND ER/A 501579-14, REPAIR CARRIED OUT RESDR DALA1217886304Skin · crackedDURING HFEC SURFACE AND OPEN HOLE INSPECTION AT LT NR 3 DOOR UPPER AFT CORNER FOUND CRACK ON SKIN SURFACE AND ONE HOLE CRACK INDICATION. INDICATE CRACK CLASSIFICATION AS SMALL AND MEDIUM. REPAIRED PER PRI 501583-14.SDR DALA1217866304Skin · crackedDURING HFEC SURFACE AND OPEN HOLE INSPECTION AT RT NR 3 DOOR UPPER AFT CORNER FOUND CRACK ON SKIN SURFACE, INDICATE CRACK CLASSIFICATION AS SMALL. REPAIRED PER PRI 501578-14.SDR DALA1219486304Floorbeam · crackedAFT CARGO DOOR SILL AREA, ONE FLOORBEAM UPPER CHORD FOUND CRACK AT BS 1840 RBL 58. REMOVED DAMAGED BEAM, FABRICATED NEW FLOORBEAM PER DRAWING 65B07267 REV D. INSTALLED NEW FLOORBEAM PER SRM 51-40-02.SDR DALA1217696304Stringer · crackedNR 3 PYLON INBOARD SIDE STRINGER AT NACELLE STA 346.402 FOUND CRACKED AT AROUND FASTENER HOLE AREA. ENTERED AND DEFERRED FOR SDR REPORTING. REPAIRED PER PRI 501588-14.SDR DALA1217676304Skin · crackedDURING HFEC SURFACE INSPECTION ON RT NR 3 DOOR CUTOUT UPPER AFT CORNER, CRACK INDICATION FOUND ON FUSELAGE SKIN AREA AS MARKED. REPAIRED PER PRI 501578-14.SDR DALA1217656304Skin · crackedDURING HFEC SURFACE INSPECTION ON LT NR 3 DOOR CUTOUT UPPER AFT CORNER, CRACK INDICATION FOUND ON FUSELAGE SKIN AREA AS MARKED. REPAIRED PER PRI 501583-14. (LP 0443605)
SDR DALA1217686304Skin · crackedINSPECTION FOUND HOLE CRACK 1 EA ON SKIN AT STA 982 STR-38R UNDER LWR DRAG SPLICE FITTING (NR 6 HOLE FROM STA 990 (EDGE OF SKIN) AS MARKED. SKIN REPAIR AND INSTALLATION CARRIED OUT AS PER B747-400 SRM 53-20-01 FIG 201 AND PRI 501602-14AD REV 0. PRI 501-602-14SDR DALA1219076304Bulkhead · out of limitsFOUND GAPS IN HOLES NR 9, 11, & 12 OF BULKHEAD. REPAIR CARRIED OUT AS PER SB747-53A2390 R1 FIG 28 AND PRI 1501571-14 REV 1.SDR DALA1217336304Seat Track · corrodedMAIN DECK CABIN SEAT TRACK AT BS 460 & LBL 68 FOUND CORROSION AS MARKED. ENTERED AND DEFERRED FOR SDR REPORTING. CORRODED SEAT TRACK AT CABIN BS460 LBL 68 AREA REMOVED AS PER B747-400 SRM 51-40-02. NEW SEAT TRACK FABRICATED AS PER BOEING 140U5286 REV A. NEWSDR DALA1217326304Seat Track · corrodedMAIN DECK CABIN SEAT TRACK AT BS 460 & LBL 91 FOUND CORROSION AS MARKED. ENTERED AND DEFERRED FOR SDR REPORTING. CORRODED SEAT TRACK AT CABIN BS460 LBL 91 AREA REMOVED AS PER B747-400 SRM 51-40-02. NEW SEAT FABRICATED AS PER BOEING DWG140US5286 REV A. NEW SESDR DALA1217316304Seat Track · corrodedMAIN DECK CABIN SEAT TRACK CROWN AT STA 580 & 91.67 FOUND CORROSION AS MARKED. ENTERED AND DEFERRED FOR SDR REPORTING. NEW SEAT TRACK FABRICATED AS PER BOEING DWG65B28626 REV NEW. NEW SEAT TRACK AT CABIN STA 580 LBL 91.67 AREA INSTALLED AS PER B747-400 SRM 5SDR DALA1217306304Frame · crackedSTA 1160, S-9R FOUND FRAME CRACK AFTER REMOVE FRAME DOUBLER FOR NRC 240-050. ENTERED AND DEFERRED FOR SDR REPORTING. STA 1160 S-9R FRAME CRACKED AREA REPAIRED AS PER B747-400 SRM 53-40-07 REPAIR 3 FIG 201.SDR DALA1221516304Frame · crackedFRAME STA 1255, BETWEEN S-4L TO S-5L FOUND ONE WEB CRACK AS MARKED. CRACKED FRAME WEB AT STA 1255 BETWEEN S-4L TO S-5L AREA REMOVED AS PER SRM 51-40-02. NEW WEB FABRICATED AS PER DWG 65B04913 REV E. NEW FRAME WEB AT STA 1255 BETWEEN S-4L TO S-5L AREA INSTALSDR DALA1216386304Door Frame · crackedDURING HFEC OPEN HOLE INSP ON AFT CARGO DOOR CUTOUT UPPER FWD CORNER, HOLES NR 2 AND NR 4 FOUND WITH CRACK INDICATION.
WORK CARRIED OUT AS PER PRI 501579-14 REV 0 AND PRI 501579-14 REV 1 FOUND IN COMPLIANCE WITH ER/A 501579-14, JOB COMPLETED.
SDR DALA1216136304Seat Track · corrodedMAIN DECK CABIN SEAT TRACK AT BS 2310 & LBL 11 FOUND CORROSION. REMOVED AS PER B747-400 SRM 51-40-02. NEW SEAT TRACK FABRICATED AS PER BOEING DWG146US5295 REV AND INSTALLED AS PER B747-400 SRM 51-40-02.SDR DALA1216116304Seat Track · corrodedMAIN DECK CABIN SEAT TRACK AT STA 2190-2270 & RBL 11. FOUND CORROSION AS MARKED. REPAIRED AS PER PRI 501573-14.SDR DALA1216096304Floor Support · corrodedMAIN DECK CABIN FLOOR SUPPORT STRUCTURE UPPER & LWR SURFACE AT BS 575-50 & LBL 98 FOUND CORROSION. REPAIRED PER PRI 501574-14.SDR DALA1216126304Seat Track · corrodedMAIN DECK CABIN SEAT TRACK AT STA 2160-2240 AND LBL 11 FOUND CORROSION AS MARKED. REPAIRED AS PER PRI 501573-14 REV 0.
Back to N664US, cancelled Jan 24, 2018