N747AS
Service difficulty reports not matched to an aircraft · 202
They name N747AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N747AS' AND registry_match IS NULL 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 = 'N747AS' AND registry_match IS NULL 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 ASAA0210049Light · inoperativeANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS AT SEAT PALLET 7-4 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY RECEIVER, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0110634Control Handle · out of adjustANC - CREW REPORTED AIRSTAIR CONTROL HANDLE DIFFICULT TO OPERATE. ADJUSTED STOP DOOR LATCH FITTING, THEN OPS CHECKED GOOD. (M)SDR ASAA0110632Handle · lack of lubeANC - CREW REPORTED AIRSTAIR CONTROL HANDLE BINDING AND DIFFICULT TO OPERATE. LUBRICATED MECHANISM, THEN OPS CHECKED GOOD. (M)SDR ASAA0110630Handle · lack of lubeANC - DURING LINE CHECK, FOUND EXTERIOR DOOR HANDLE ON L-1 DOOR STICKS, HARD TO OPEN. CLEANED OFF ICE FROM HANDLE AREA, CLEANED AND LUBED SHAFT, OPERATIONS CHECK NORMAL. (M)SDR ASAA0110596Sign · inoperativeANC - DURING SCHEDULED MAINTENANCE, FOUND RIGHT OVERWING EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY, LIGHT TESTED NORMAL. (M)SDR 2001F00646Battery · dischargedPAE - DURING SCHEDULED MAINTENANCE, FOUND AFT CABIN EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY AND BATTERY, LIGHT TESTED NORMAL. REF ASAA0110556. (M)SDR ASAA0110556Sign · inoperativePAE - DURING SCHEDULED MAINTENANCE, FOUND AFT CABIN EMERGENCY EXIT SIGN INOPERATIVE. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY AND BATTERY, LIGHT TESTED NORMAL. (M)SDR ASAA0110479Intercostal · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL AT BS 685, LEFT BUTTOCK LINE 60-66 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110480Intercostal · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL AT BS 705, LEFT BUTTOCK LINE 60-66 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110481Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 887-916, STRINGER 26R-27R CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110483Intercostal · crackedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL AT BS 440-460, STRINGER 26L CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110487Structure · crackedPHX - DURING SCHEDULED D-CHECK, FOUND MAIN CARGO DOOR AT BS 380-480, STRINGER 16L HAS CRACKED AND BROKEN RIVET HEADS WITH CRACKS EMANATING FROM RIVETS. REPAIRED PER SRM. (M)SDR ASAA0110488Skin · gougedPHX - DURING SCHEDULED D-CHECK, FOUND SKIN PANEL AT BS 967-977, STRINGER 19L-22L GOUGED. REPAIRED PER SRM. (M)SDR ASAA0110489Tie Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND FRAME TIE CLIP AT BS 380, LBL 64 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110484Tie Clip · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER TIE AT BS 540, STRINGER 23L-24L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110485Gusset · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND BULKHEAD GUSSET AT BS 227, LBL 3 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110486Seat Track · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK AT BS 344-520, LBL 62.5 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110482Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SUPPORT ANGLE AT BS 300-344, LEFT BUTTOCK LINE 38 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110478Strap · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRAP AT BS 680-690, LEFT BUTTOCK LINE 60-66 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110476Strap · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRAP AT BS 690-693, LEFT BUTTOCK LINE 60-66 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110477Strap · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRAP AT BS 540-727, LEFT BUTTOCK LINE 60 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110474Strap · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRAP AT BODY STATION 696-705, STRINGER 18L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110475Strap · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRAP AT BODY STATION 693-696, LEFT BUTTOCK LINE 60-66 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110471Tie Clip · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND TIE CLIP AT BS 867, STRINGER 27L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110473Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND ANGLE AT BS 695, STRINGER 18L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110465Attach Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND ATTACH ANGLES AT BS 695, LEFT BUTTOCK LINE 60 CORRODED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110468Attach Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND ATTACH ANGLES AT BS 695, LEFT BUTTOCK LINE 60 CORRODED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110467Attach Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND ATTACH ANGLES AT BS 695, LEFT BUTTOCK LINE 60 CORRODED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110466Attach Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND ATTACH ANGLES AT BODY STATION 695, LEFT BUTTOCK LINE 60 CORRODED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110464Seat Track · wornPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK LUGS AT BS 420-480, LEFT BUTTOCK LINE 24.5 WORN. REPAIRED PER SRM. (M)SDR ASAA0110463Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 520-540, LEFT BUTTOCK LINE 24.7 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110462Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BODY STATION 520-540, LEFT BUTTOCK LINE 25 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110461Frame · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FRAME AT BS 500A, STRINGER 21R-25R CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110436Intercostal · crackedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL SUPPORT AT BS 400-420, LBL 22 CRACKED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110435Shear Tie · crackedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 440, LBL 69 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110434Attach Angle · crackedPHX - DURING SCHEDULED D-CHECK, FOUND ATTACH ANGLE BS 380, STRINGER 25L-26L CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110432Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK SUPPORT BEAM AT BS 520, RBL 46 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110431Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK SUPPORT BEAM AT BS 663-685, LEFT BUTTOCK LINE 64 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110433Skin · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SKIN PANEL AT BS 927, STRINGER 27L-27R CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110429Shear Tie · crackedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 480, LBL 69 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110428Skin Panel · dentedPHX - DURING SCHEDULED D-CHECK, FOUND SKIN PANEL AT BODY STATION 897, STRINGER 18R DENTED. REPAIRED PER SRM. (M)SDR ASAA0110430Intercostal · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL AT BODY STATION 847-867, STRINGER 26R CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110412Attach Angle · damagedPHX - DURING SCHEDULED D-CHECK, FOUND ATTACH ANGLE AT BS 480, RBL 74 HAS ELONGATED HOLES. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110413Shear Tie · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 927, STRINGER 27L-27R CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110415Angle · damagedPHX - DURING SCHEDULED D-CHECK, FOUND ANGLE AT BS 440, STRINGER 27R DAMAGED. REPAIRED PER SRM. (M)SDR ASAA0110410Intercostal · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL LINK AT BS 520-540, LBL 45 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110406Skin Panel · damagedPHX - DURING SCHEDULED D-CHECK, FOUND SKIN PANEL REPAIR AT BS 727, STRINGER 23L-24L REQUIRED PERMANENT REPAIR. REPAIRED PER SRM. (M)SDR ASAA0110407Intercostal · crackedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL AT BS 330, STRINGER 26L-27L CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110408Frame · gougedPHX - DURING SCHEDULED D-CHECK, FOUND FRAME AT BS 348.2, STRINGER 11L-12L GOUGED. REPAIRED PER EA. (M)SDR ASAA0110409Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 520-540, LBL 45 CORRODED. REPAIRED PER SRM. (M)
Back to N747AS