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 ASAA0310001Battery Pack · dischargedANC - DURING RECON INSPECTION, FOUND INSTALLED PALLET ARRIVED WITH DISCHARGED BATTERY. REMOVED AND REPLACED BATTERY PACK, THEN LIGHTS OPERATED NORMALLY. (M)SDR ASAA0210253Battery Pack · dischargedDURING PREFLIGHT CHECK FOUND EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE ON PALLET 8-9. REMOVED AND REPLACED THE BATTERY PACK. THE TRACK LIGHTS THEN OPERATED NORMALLY.SDR ASAA0210183Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS WOULD NOT TEST AT ROW 15. REMOVED AND REPLACED THE BATTERY PACK. THE TRACK LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0210151Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS AT SEAT PALLET 8-9 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY THEN LIGHTS OPERATED NORMAL. (M)SDR ASAA0210082Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SHEAR TIE AT BS 520, STRINGER 28R CORRODED. REPAIRED DENT PER SRM. (M)SDR ASAA0210083Skin · crackedPAE - DURING SCHEDULED C-CHECK, FOUND AFT ENTRY DOOR (L2) SKIN PANEL CRACKED AT BS 986, STRINGER 7L-8L CRACKED. REPAIRED DENT PER SRM. (M)SDR ASAA0210081Skin · dentedPAE - DURING SCHEDULED C-CHECK, FOUND FORWARD GALLEY DOOR SKIN DENTED. REPAIRED DENT PER SRM. (M)SDR ASAA0210079Skin · dentedPAE - DURING SCHEDULED C-CHECK, FOUND INNER SKIN ON AFT CARGO DOOR DENTED AT BS 800, STRINGER 25R. REPAIRED DENT PER SRM. (M)SDR ASAA0210061Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTS WOULD NOT TEST IN THE AFT CABIN. REMOVED AND REPLACED THE TWO MOST AFT REMOTE ASSEMBLY BATTERY THEN LIGHTS OPERATED NORMAL. (M)SDR ASAA0210045Guide · brokenSEA - DURING MAINTENANCE CHECK, FOUND L1 DOOR GUIDE ARM ASSEMBLY BROKEN. REMOVED AND REPLACED GUIDE ARM ASSEMBLY, THEN DOOR OPERATED NORMALLY. (M)SDR ASAA0210040Bracket · brokenANC - DURING MAINTENANCE CHECK, FOUND UPPER HINGE COVER BRACKET BROKEN CAUSING THE L1 DOOR TO BE DIFFICULT TO CLOSE. REMOVED AND REPLACED BRACKET, THEN DOOR OPERATED NORMALLY. (M)SDR ASAA0110648Wire · brokenANC - EMERGENCY FLOOR TRACK LIGHTING AT ROW 7, SEAT PALLET 4-9 INOPERATIVE DUE TO BROKEN WIRE. REPAIRED BROKEN WIRE, THEN LIGHT OPS CHECKED GOOD. (M)SDR ASAA0110644Switch · malfunctionedANC - SOME EMERGENCY EXIT LIGHTING WILL NOT EXTINGUISH WITH FLIGHT DECK SWITCH IN ARMED POSITION. REMOVED AND REPLACED AFT FLIGHT ATTENDANTS CONTROLS SWITCH THEN LIGHTS OPERATED NORMAL. (M)SDR ASAA0110633Mechanism · lack of lubeANC - CREW REPORTED AIRSTAIR MECHANISM DIFFICULT TO OPERATE. LUBRICATED MECHANISM, THEN OPS CHECKED GOOD. (M)SDR ASAA0110628Latch · lack of lubeANC - DURING LINE CHECK, FOUND L1 DOOR HOLD OPEN LATCH INOPERATIVE. LUBRICATED LATCH OPERATIONAL CHECK NORMAL. (M)SDR ASAA0110627Battery Pack · dischargedFAI - DURING LINE CHECK, FOUND EMERGENCY EXIT LIGHTING AT SEAT PALLET NR 4 INOPERATIVE. REMOVED AND REPLACED EXIT LIGHT BATTERY PACK, OPERATIONAL CHECK NORMAL. (M)SDR 2001F00249Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS AT SEAT PALLETS 6-9 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND RECEIVER THEN LIGHTS OPERATED NORMAL. REF ASAA0110313. (M)SDR ASAA0110313Receiver · inoperativeSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHTS AT SEAT PALLETS 6-9 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AND RECEIVER THEN LIGHTS OPERATED NORMAL. (M)SDR ASAA0110275Receiver · inoperativeANC - DURING A LINE MAINTENANCE CHECK, THE EMERGENCY TRACK LIGHTING WAS FOUND TO BE INOPERATIVE ON PALLETS 6 AND 7. REPLACED THE EMERGENCY LIGHTING REMOTE RECEIVER ON PALLETS 6 AND 7. THE LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0110239Handle · lack of lubeSEA - DURING MAINTENANCE CHECK, FOUND L2 DOOR HANDLE STIFF. LUBED HANDLE, THEN HANDLE OPERATED NORMALLY. (M)SDR 2001F00139Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMERGENCY EXIT LIGHT ON THE SMOKE BARRIER WOULD NOT TEST. REMOVED AND REPLACED LIGHT ASSEMBLY AND BATTERY, THEN LIGHT OPERATED NORMALLY. REF ASAA0110230. (M)SDR ASAA0110230Battery · dischargedSEA - DURING MAINTENANCE CHECK, FOUND EMEREGNCY EXIT LIGHT ON THE SMOKE BARRIER WOULD NOT TEST. REMOVED AND REPLACED LIGHT ASEMBLY AND BATTERY, THEN LIGHT OPERATED NORMALLY. (M)SDR ASAA0110220Door Frame · crackedPAE - DURING MAINTENANCE, FOUND FRAME AROUND MAIN CARGO DOOR CUTOUT AT BS 472.4, STRINGER 24R CRACKED. REPAIRED PER EA. (M)SDR ASAA0110204A/C Pack · malfunctionedANC - IMMEDIATELY AFTER DEPARTURE, NOTED STRONG ODOR ONLY IN COCKPIT. ODOR DISSIPATED BUT RETURNED INTERMITTENTLY OVER THE NEXT SIXTY MINUTES. UNABLE TO ISOLATE THE CAUSE OF THE ODOR. BORESCOPED AND CLEANED BOTH ENGINE BLEED AIR DUCTS AND PACK COMPONENTS FRSDR ASAA0110192O-Ring · nickedANC - FLT 64 - FLIGHT ATTENDANT REPORTED CHEMICAL ODOR ON CLIMBOUT WHICH DISSIPATED AFTER A FEW MINUTES. NO OTHER REPORTS WERE NOTED. AIRCRAFT LANDED IN JNU WITHOUT INCIDENT. MAINTENANCE INSPECTED AIRCRAFT AND ENGINES FOR FERRY FLIGHT TO SEA FOR TROUBLESHOOSDR ASAA0110191Smoke · detectedANC - ABORTED TAKEOFF OF FLT 151, BOTH THE FIRST OFFICERS AND OBSERVER NOTED SMOKE IN THE COCKPIT DURING TAKEOFF. BOTH PACKS WERE TURNED OFF AS AIRCRAFT CLEARED RUNWAY. ANC MAINTENANCE INSPECTED BOTH ENGINES AND APU INLETS AND EXHAUST, NO DEFECTS NOTED. RANSDR ASAA0110170Handle · stiffANC - DURING MAINTENANCE CHECK, FOUND L2 DOOR HANDLE STIFF TO OPERATE. CLEANED AND LUBED HANDLE AND HANDLE OPERATED NORMALLY. (M)SDR ASAA0110169Wire · disconnectedSEA - DURING MAINTENANCE CHECK, FOUND WIRES DISCONNECTED TO LIGHTED EMERGENCY EXIT SIGN. RECONNECTED WIRES AND LIGHT OPERATED NORMALLY. (M)SDR ASAA0110160Seat Track · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK AT BS 360-390, BL 0 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110152Clip · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR CLIP AT BS 360, STRINGER 26L-27L CORRODED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110153Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 270, LBL 11, RBL 11 CORRODED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110154Stringer · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER 26R AT BS 270, CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110155Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND TEE CAP ATTACHING ANGLE AT BS 312, STRINGER 27L-28L CORRODED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110157Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND ANGLE AT BS 360, STRINGER 28L CORRODED. REMOVED AND REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110158Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT ANGLE AT BS 737-947, STRINGER 27L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110159Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SEAT TRACK SUPPORT AT BS 540-639, LBL 62 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110149Floorbeam · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 500B, BL 0 - LBL 55 CORRODED. REPAIRED PER EA. (M)SDR ASAA0110148Floor Support · crackedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 410-510, STRINGER 27R CRACKED. REPAIRED PER SRM. (M)SDR ASAA0110147Stringer Clip · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 967, STRINGER 24L CORRODED. REPAIRED PER BOEING DRAWING. (M)SDR ASAA0110139Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBOARD SUPPORT TRACK AT BS 737-874, STRINGER 27L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110140Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBOARD SUPPORT TRACK AT BS 737-947, LEFT BUTTOCK LINE 10 CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110141Angle · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND ANGLE AT BS 357, LBL 15 CORRODED. REMOVED, FABRICATED AND REPLACED ANGLE PER BOEING DRAWING. (M)SDR ASAA0110142Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT AT BS 270-277, RBL 11 CORRODED. REMOVED, FABRICATED AND REPLACED FLOOR SUPPORT PER BOEING DRAWING. (M)SDR ASAA0110143Strap · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND STRAP AT BS 500, BL 0 TO LBL 55 CORRODED. (M)SDR ASAA0110144Floorbeam · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 420, BL 0 TO LBL 55 CORRODED. REPAIRED PER EA. (M)SDR ASAA0110145Skin Panel · chafedPHX - DURING SCHEDULED D-CHECK, FOUND EXTERIOR SKIN PANEL HAS A DEEP CHAFE MARK AT BS 794 NEAR THE AFT DOOR EDGE. REPAIRED PER SRM. (M)SDR ASAA0110135Shear Tie · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND SHEAR TIE AT BS 727B, STRINGER 26L-28L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110137Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT ANGLE AT BS 767, STRINGER 27R CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110138Floor Support · corrodedPHX - DURING SCHEDULED D-CHECK, FOUND FLOOR SUPPORT ANGLE AT BS 727B, STRINGER 26L CORRODED. REPAIRED PER SRM. (M)SDR ASAA0110122Clip · crackedPHX - DURING SCHEDULED D-CHECK, FOUND STRINGER CLIP AT BS 727B, LBL 6 CRACKED. REPAIRED PER SRM. (M)
Back to N730AS