N730AS
Service difficulty reports not matched to an aircraft · 393
They name N730AS, 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 = 'N730AS' 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 = 'N730AS' 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 ASAA0110123Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 787, LBL 16 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110124Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 747, RBL 6 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110125Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 747, RBL 7 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110126Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP BS 727B, RBL 9 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110127Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 727B, RBL 7 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110128Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 727A, RBL 8 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110129Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 616, RBL 6 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110130Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 597, RBL 8 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110131Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 597, RBL 5 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110132Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 578, RBL 8 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110133Stringer Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 639, LBL 4 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110134Splice · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE SPLICE STRAP AT BS 360-372, STRINGER 28L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110117Intercostal · damagedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL BS 342-350, LBL 42.5 HAS ELONGATED HOLES. REPAIRED PER SRM. (M)SDR ASAA0110114Stringer · corrodedPHX - DURING D-CHECK FOUND STRINGER 27R, BS 360-430 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110115Intercostal · damagedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL AT BS 340-360, BUTTOCK LINE 0 WITH ELONGATED HOLES. (M)SDR ASAA0110116Frame · crackedPHX - DURING SCHEDULED D-CHECK, FOUND FRAME AT BS 440, STRINGER 26R CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110113Skin · dentedPHX - DURING SCHEDULED D-CHECK, FOUND FUSELAGE SKIN AT BS 440-480, STRINGER 26R DENTED. (M)SDR ASAA0110111Bulkhead · crackedPHX - DURING SCHEDULED D-CHECK, FOUND BULKHEAD AT BS 178, LBL 7 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110112Bulkhead · crackedPHX - DURING SCHEDULED D-CHECK, FOUND BULKHEAD AT BS 178, WL 200, LBL 7 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110106Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 540, RIGHT BUTTOCK LINE 2-22 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110103Intercostal · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND INTERCOSTAL AT BS 302, STRINGER 27L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110104Stiffener · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STIFFENER AT BODY STATION 178, LEFT BUTTOCK LINE 6 CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110101Frame · crackedPHX - DURING SCHEDULED D-CHECK, FOUND FRAME AT BS 597, STRINGER 13L-18R CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110102Frame · crackedPHX - DURING SCHEDULED D-CHECK, FOUND CHORD AT BODY STATION 178, STRINGER 20L CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110100Frame · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND CHORD AT BS 294-366, STRINGER 27L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110105Floorbeam · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 294.5, RIGHT BUTTOCK LINE 24, LEFT BUTTOCK LINE 26 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110018Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND SMOKE BARRIER EMERGENCY EXIT LIGHT BATTERY WOULD NOT TEST. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND LIGHT OPERATED NORMALLY. (M)SDR ASAA0110001Battery · dischargedSEA - DURING MAINTENANCE CHECK, EMERGENCY LIGHT TRANSMITTER INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT TRANSMITTER BATTERY. LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010185Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY TRACK LIGHT RECEIVER WILL NOT TEST AT ROW 18. REPLACED BATTERY PACK, LIGHTS TESTED NORMALLY. (M)SDR 20010112SG059Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, FOUND AFT PALLET EMERGENCY EXIT LIGHTING INOPERATIVE. REPLACED REMOTE ASSEMBLY RECEIVER AND BATTERY PACK. LIGHTS TESTED NORMALLY. REF ASAA0010182. (M)SDR ASAA0010182Receiver · inoperativeANC - DURING MAINTENANCE CHECK, FOUND AFT PALLET EMERGENCY EXIT LIGHTING INOPERATIVE. REPLACED REMOTE ASSEMBLY RECEIVER AND BATTERY PACK. LIGHTS TESTED NORMALLY. (M)SDR ASAA0010179Receiver · inoperativeANC - DURING MAINTENANCE CHECK, FOUND SECTION OF EMERGENCY EXIT TRACK LIGHTING WILL NOT SHUT OFF. REPLACED TRACK LIGHT REMOTE ASSEMBLY RECEIVER FOR INOPERATIVE SECTION. SECTION OPERATED NORMALLY. (M)SDR 20010112SG053Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, FOUND ROW 12 RECEIVER WILL NOT PASS EMERGENCY EXIT LIGHT TEST. REMOVED AND REPLACED ASSY RECEIVER AND BATTERY PACK, OPS NORMAL. (M)REF ASAA0010178.SDR ASAA0010178Receiver · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND ROW 12 RECEIVER WILL NOT PASS EMERGENCY EXIT LIGHT TEST. REPLACED REMOVE ASSY RECEIVER AND BATTERY PACK, OPS NORMAL. (M)SDR ASAA0010177Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, FOUND AFT ENTRY EMERGENCY ESCAPE LIGHTS INOPERATIVE. REPLACED BATTERY PACK, OPS NORMAL. (M)SDR ASAA0010176Receiver · inoperativeANC - DURING MAINTENANCE CHECK, FOUND FLOOR EMERGENCY EXIT LIGHTS ON SEAT PALLET 5-8 WILL NOT EXTINGUISH. REPLACED REMOTE ASSY RECEIVER, OPS NORMAL. (M)SDR 20010112SG054Power Supply · inoperativeANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS ON SEAT PALLET 8-2 WOULD NOT EXTINGUISH AND L2 AND R2 EXTERIOR ESCAPE LIGHTS WERE INOPERATIVE. REMOVED AND REPLACED BATERY PACK ON SEAT PALLET 8-2, OPS NORMAL, AND REPLACED POWER SUPPLY TO L2 AND R2 SDR ASAA0010175Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS ON SEAT PALLET 8-2 WOULD NOT EXTINGUISH AND L2 AND R2 EXTERIOR ESCAPE LIGHTS WERE INOPERATIVE. REMOVED AND REPLACED BATERY PACK ON SEAT PALLET 8-2, OPS NORMAL, AND REPLACED POWER SUPPLY TO L2 AND R2 SDR ASAA0010172Receiver · failedSEA-DURING MAINTENANCE CHECK FOUND EMERGENCY EXIT LIGHTS AT ROWS 2 AND 6 WOULD NOT TEST. REPLACED REMOTE ASSEMBLY RECEIVER AT ROW 2 AND REMOTE ASSEMBLY BATTERY AT ROW 6. LIGHTS TESTED NORMALLY.SDR ASAA0010171Battery Pack · dischargedSEA-DURING MAINTENANCE CHECK FOUND EMERGENCY EXIT LIGHTS AT ROW 8 WILL NOT EXTINGUISH. REPLACED BATTERY PACK. LIGHTS WORKED PROPERLY.SDR ASAA0010168Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, EMERGENCY EXIT LIGHTS AT ROW 16 WOULD NOT TEST. REPLACED BATTERY PACK, LIGHTS OPERATED NORMALLY. (M)SDR ASAA0010165Battery · dischargedSEA-DURING MAINTENANCE CHECK FOUND SMOKE BARRIER AND AFT SEAT PALLET EMERGENCY EXIT LIGHTS INOPERATIVE.REPLACED AFT SEAT PALLET AND SMOKE BARRIER REMOTE ASSEMBLY BATTERY. LIGHTS TESTED NORMAL.SDR ASAA0010150Battery Pack · inoperativeSEA-DURING MAINTENANCE CHECK FOUNT AFT SERVICE DOORS EXTERIOR EMERGENCY EXIT LIGHTS INOPERATIVE. REPLACED EMERGENCY EXIT LIGHTS BATTERY PACK FOR AFT SERVICE DOORS AND THE LIGHTS OPERATED NORMAL.SDR ASAA0010148Light · inoperativeANC-DURING MX CHECK EMERGENCY LIGHTS ON SEAT PALLET 7-7 WOULD NOT ILLUMINATE. REPLACED EMERGENCY LIGHT RECEIVER ASSY.SDR ASAA0010138Charger · inoperativeYXD-DURING SERVICE CHECK THE RT OVERWING INTERIOR LOWER EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. RELEASED PER MEL 33-15A. SEA MAINTENANCE SUBSEQUENTLY REPLACED BATTERY CHARGER AND REPAIRED SHORTED WIRE. THE LIGHT OPERATED NORMALLY.SDR ASAA0010137Shear Tie · missingYXD-DURING SCHEDULED MAINTENANCE STA 500B FRAME SHEAR TIE MISSING BETWEEN STRINGER 4R AND 13R. REPAIRED PER BOEING DRAWING 65-64958 REV. D.SDR ASAA0010135Door Frame · crackedYXD-DURING SCHEDULED MAINTENANCE STA 480 FRAME WAS FOUND TO BE CRACKED THROUGH THE OUTBOARD FLANGE TERMINATING IN A FASTENER HOLE COMMON TO THE REINFORCEMENT STIFFNER VERTICAL LEG. REPAIRED PER EA 5310-01719.SDR ASAA0010136Shear Tie · missingYXD-DURING SCHEDULED MAINTENANCE STA 480 FRAME SHEAR TIE MISSING BETWEEN STRINGER 4R AND 10R. REPAIRED PER BOEING DRAWING 65-46532.SDR 20010111SG007Receiver · inoperativeSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT LIGHT BATTERY PACK AND RECEIVER WERE FOUND TO BE INOPERATIVE. REPLACED THE RECEIVER AND BATTERY PACK, LIGHTS OPERATED NORMALLY. REF ASAA0010128. (M)SDR ASAA0010128Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT LIGHT BATTERY PACK AND RECEIVER WERE FOUND TO BE INOPERATIVE. REPLACED THE RECEIVER AND BATTERY PACK, LIGHTS OPERATED NORMALLY. (M)
Back to N730AS