JASC 5330
Service difficulty reports · 79,365
Reports filed under 5330 · Fuselage Main, Plate/Skin, 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 jasc_code = '5330' 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 jasc_code = '5330' 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 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 SWAA2012041903248Skin · crackedFUSELAGE SKIN CRACKED AT FWD LOWER CORNER CUTOUT L2 DOOR AT BS 947.5+14", ABOVE STR 17L. REPAIRED SKIN PER SRM.SDR SWAA2012041903245Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 887+10 UPPER AFT WINDOW CORNER. REPAIRED SKIN PER EA.SDR SWAA2012041903244Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 400+10 LOWER AFT WINDOW CORNER. REPAIRED SKIN PER EA.SDR SWAA2012041803223Skin · crackedLT FUSELAGE SKIN AT BS 727B+10 UPPER AFT WINDOW CORNER CRACKED. REPAIRED SKIN PER EA.SDR SWAA2012041803222Skin · crackedRT FUSELAGE SKIN AT BS 360+10 UPPER FORWARD WINDOW CORNER CRACKED. REPAIRED SKIN PER EA.SDR SWAA2012041803192Skin · crackedRT FUSELAGE SKIN AT BS 360+10 LOWER FWD WINDOW CORNER CRACKED. REPAIRED SKIN PER EA.SDR SWAA2012041803191Skin · crackedRT FUSELAGE SKIN AT BS 530 UPPER FORWARD WINDOW CORNER CRACKED. REPAIRED SKIN PER EA.SDR SWAA2012041803190Skin · crackedRT FUSELAGE SKIN AT BS 500C+10 UPPER FORWARD WINDOW CORNER CRACKED. REPAIRED SKIN PER EA.SDR SWAA2012041603142Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 480+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012041603141Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500A+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012041603140Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA.SDR SWAA2012041303112Skin · crackedLEFT FUSELAGE SKIN CRACKED AT BS 727+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW EA AND REO.SDR SWAA2012041203071Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 867+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041203070Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 847+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN AW SB.SDR SWAA2012041203069Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 827+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041203068Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 787+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041203062Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 787+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041203061Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 887+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041203060Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 807+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041203059Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 867+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041103028Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 827+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041103018Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041103017Skin · crackedLT FUSELAGE SKIN CRACKED AT BS 807+10 LOWER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041103016Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 440+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN PER SRM AND EA.SDR SWAA2012041103015Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 440+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN PER SRM AND EA.SDR SWAA2012041002961Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 847+10 UPPER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002960Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500B+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002959Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500A+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002958Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002957Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 460+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002956Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 420+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002955Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 380+10 LOWER AFT WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002954Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 500B+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002953Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 480+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002952Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 420+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002951Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 400+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR SWAA2012041002950Skin · crackedRT FUSELAGE SKIN CRACKED AT BS 380+10 UPPER FORWARD WINDOW CORNER CUTOUT. REPAIRED SKIN IAW SB.SDR IPXA12672772Skin · corrodedINSPECTION TYPE:8C, FUSELAGE RT BS 955 BULKHEAD SIDE FITTING - A SLIGHTY CORROSION IS FOUND AFTER FAIL-SAFE STRAP TRIMMED OFF AT THE INTERNAL SURFACE OF THE SKIN IN THE AREA WHERE THE T-FITTING TO THE FAIL-SAFE STRAP AREA. CORROSION REMOVED IAW SRM 51-10-02 &SDR IPXA12672768Skin · corrodedINSPECTION TYPE: 8C, FUSELAGE LT BS 955 BULKHEAD SIDE FITTING, SLIGHT CORROSION IS FOUND AFTER FAILSAFE TRIMMED OFF AT THE INTERNAL SURFACE OF THE SKIN IN THE AREA WHERE THE TEE FITTING TO THE FAILSAFE STRAP AREA. CORROSION REMOVED IAW SRM 51-10-02 & REPROTECSDR SWAA2012032702618Skin · crackedSKIN CRACKED AT BS 727D+2, STR 19R. REPAIRED SKIN PER SRM.SDR UALA2012032301862Skin · damagedPER JIC 49795401C REQUIRES REMOVAL OF RT AIRPHONE ANTENNA AND SKIN DOUBLER TO BE INSTALLED. MAJOR REPAIR ACCOMPLISHED: REMOVED AIRPHONE ANTENNA & INSTALLED SKIN DOUBLER. THIS ITEM ACCOMP COA 40795C.SDR UALA2012032301861Skin · damagedJIC 49795401C DURING HMV 3 VISIT REQUIRES LT AIRPHONE ANTENNA REMOVED AND SKIN DOUBLER INSTALLED. MAJOR REPAIR ACCOMPLISHED: INSTALLED SKIN DOUBLER PER SRM. SRI REQUIREMENTS REF SRI 53-00-11-TABLE 219. INSTALLED SKIN DOUBLER.SDR UALA2012032301860Doubler · faultyEXISTING SKIN DOUBLER AT FR 73- 74, STR 31R-33R.33R. REMOVED EXISTING RPR AND INSTALLED NEW DOUBLER RPR PER SRM.SDR MASA2012032234604Skin · chafedAFT FUSELAGE BOTTOM SKIN HAS TWO CHAFES BETWEEN FS 959 AND FS 969 ON A PREVIOUSLY REPAIRED AREA. C/W RO CRJ 7-53-0558.SDR SWAA2012050203637Skin · crackedSKIN CRACKED AT BS 698, RBL 6.50. REPAIRED SKIN IAW SRM.SDR DALA1224550930Skin · damagedSCRATCHES AND LIGHTNING STRIKES AT LWR CORNER OF WINDOW BELT FRAME. REWORK ACCOMPLISHED STATED AS IAW ERA 51110-14 REV ORIG.SDR DALA1219359255Skin · damagedFWD CARGO RT SIDE AT STR 22RT AND 23RT 3 BAD RIVETS AT STA 332. INSTALLED PERMANENT FLUSH REPAIR PER MD 90 SRM 53-30-01 FIG 5 VOL I.SDR USAA2012032200006Skin · crackedRON VISIT - 3 INCH CRACK IN FUSELAGE SKIN AT BS 727E+4 INCHES, S23L. REPAIRED FUSELAGE SKIN AT BS 727E+4 INCHES, S23L IAW B737 SRM 53-00-01 REPAIR 31 DETAIL XI.SDR SWAA2012032302526Skin · crackedFUSELAGE SKIN CRACKED AT BS 344+1, STR 2L. REPAIRED SKIN PER SRM.
Back to JASC 5330