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 ASAA9610122Floor Beam · crackedSEA - DURING D-CHECK, BS 520 LBL 24.75 FLOOR BEAM UPPER CHORD WAS FOUND CRACKED IN RADIUS. REPAIRED PER EA 5310-01485 AND BOEING TELEX ASA-SEA-96-0392RR. (M)SDR ASAA9610121Floor Beam · crackedSEA - DURING D-CHECK, BS 520 RBL 24.75 FLOOR BEAM UPPER CHORD WAS FOUND CRACKED IN RADIUS. REPAIRED PER EA 5310-01485 AND BOEING TELEX ASA-SEA-96-0392RR. (M)SDR ASAA9610120Floor Beam · corrosionSEA - DURING D-CHECK, THE FLOOR BEAM FORWARD LOWER FLANGE AT BS 520, LBL 40 TO LBL 45 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01487 AND BOEING TELEX ASA-SEA-96-0392RR. (M)SDR ASAA9610119Floor Beam · corrosionSEA - DURING D-CHECK, THE FLOOR BEAM FORWARD FLANGE AT BS 520, LBL 35 TO LBL 43 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01487 AND BOEING TELEX ASA-SEA-96-0392RR. (M)SDR ASAA9610116Floor Beam · corrodedSEA - DURING D-CHECK, THE LOWER FORWARD FLANGE OF THE FLOOR BEAM AT BS 500B, LBL 35 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01464 AND BOEING TELEX ASA-SEA-96-0340RR. (M)SDR ASAA9610115Floor Beam · corrodedSEA - DURING D-CHECK, THE LOWER FORWARD FLANGE OF THE FLOOR BEAM AT BS 867, LBL 23 TO RBL 46 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01477 AND BOEING TELEX ASA-SEA-96-0354RR. (M)SDR ASAA9610114Floor Beam · corrodedSEA - DURING D-CHECK, THE LOWER FORWARD FLANGE OF THE FLOOR BEAM AT BS 767, RBL 24 TO 30 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01465 AND BOEING TELEX ASA-SEA-96-0339RR. (M)SDR ASAA9610112Floor Beam · corrodedSEA - DURING D-CHECK, THE UPPER FORWARD FLANGE OF THE FLOOR BEAM AT BS 500A, LBL 25 TO 43 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01472 AND BOEING TELEX ASA-SEA-96-0353RR. (M)SDR ASAA9610111Floor Beam · corrodedSEA - DURING D-CHECK, THE FORWARD UPPER HORIZONTAL FLANGE OF THE FLOOR BEAM AT BS 420, LBL 46 TO 58 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01474 AND BOEING TELEX ASA-SEA-96-0372RR. (M)SDR ASAA9610110Floor Beam · corrodedSEA - DURING D-CHECK, THE FORWARD LOWER HORIZONTAL FLANGE OF THE FLOOR BEAM AT BS 420, LBL 5.25 TO 46 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01480 AND BOEING TELEX ASA-SEA-96-0379RR. (M)SDR ASAA9610160Door Beam · crackedSEA - DURING D-CHECK, THE MAIN CARGO DOOR UPPER BEAM AFT END WAS FOUND TO HAVE A 1.3 INCH CRACK. REPAIRED PER EA 5230-01062 AND BOEING TELEX ASA-SEA-96-0302RR. (M)SDR ASAA9610109Floor Beam · corrodedSEA - DURING D-CHECK, THE UPPER FORWARD FLANGE OF THE FLOOR BEAM AT BS 1016, RBL 30 TO 40 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01481 AND BOEING TELEX ASA-SEA-96-0378RR. (M)SDR ASAA9610108Floor Beam · corrodedSEA - DURING D-CHECK, THE LOWER FORWARD FLANGE OF THE FLOOR BEAM AT BS 500, LBL 5 TO 48 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01463 AND BOEING TELEX ASA-SEA-96-042RR. (M)SDR ASAA9610107Skin · crackedSEA - DURING D-CHECK, A 1.5 INCH CRACK WAS FOUND IN THE SKIN AT THE ELECTRONICS COMPARTMENT COOLING DUCT CUTOUT. REPAIRED PER EA 5330-01261 AND BOEING SERVICE BULLETIN 737-53-1117 REV 1. (M)SDR ASAA9610105Floor Beam · corrodedSEA - DURING D-CHECK, THE AFT LOWER HORIZONTAL FLANGE OF THE FLOOR BEAM AT BS400, LBL 55 TO 65 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01475 AND BOEING TELEX ASA-SEA-96-0374RR. (M)SDR ASAA9610102Floor Beam · corrodedSEA - DURING D-CHECK, THE UPPER FORWARD FLANGE OF THE FLOOR BEAM BS 500A, LBL 42 TO RBL 43 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01471 AND BOEING TELEX ASA-SEA-96-0355RR. (M)SDR ASAA9610101Floor Beam · corrodedSEA - DURING D-CHECK, THE UPPER AFT FLANGE OF THE FLOOR BEAM BS 887, RBL 4 TO LBL 51 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01468 AND BOEING TELEX ASA-SEA-96-0348RR. (M)SDR ASAA9610100Floor Beam · corrodedSEA - DURING D-CHECK, THE LOWER FLANGE OF THE FLOOR BEAM BS 460, LBL 42.5 WAS FOUND TO BE CORRODED. REPARIED PER EA 5310-01459 AND BOEING TELEX ASA-SEA-96-0326RR. (M)SDR ASAA9610099Floor Beam · corrodedSEA - DURING D-CHECK, A PREVIOUS REPAIR OF THE UPPER FORWARD FLANGE OF THE FLOOR BEAM BS 967 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01457 AND BOEING TELEX ASA-SEA-94-0307RR. (M)SDR ASAA9610098Floor Beam · corrodedSEA - DURING D-CHECK, THE LOWER FORWARD FLANGE OF THE FLOOR BEAM BS 480, LBL 42 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01461 AND BOEING TELEX ASA-SEA-96-0332RR. (M)SDR ASAA9610097Floor Beam · corrodedSEA - DURING D-CHECK, THE LOWER FORWARD FLANGE OF THE FLOOR BEAM BS 440, LBL 42.75 WAS FOUND TO BE CORRODED. REPAIRED PER EA 5310-01460 AND BOEING TELEX ASA-SEA-96-0327RR. (M)SDR ASAA9610096Stringer · crackedSEA - DURING D-CHECK, A CRACK WAS IDENTIFIED AT THE ENDS OF STRINGER 16R, BS 500B, WHICH TERMINATES AT THE RIGHT WING LEADING EDGE LIGHT. REPAIRED PER EA 5310-1456 AND BOEING SERVICE BULLETIN 737-53-1145. (M)SDR ASAA9610094Floor Beam · corrodedSEA - DURING D-CHECK, THE UPPER CHORD FLANGE OF STATION 328 FLOOR BEAM (CABIN) WAS FOUND CORRODED. REPLACED CHORD AND SPLICED AT LBL 33 PER EA 5310-01454 AND BOEING TELEX ASA-SEA-94-0292RR. (M)SDR ASAA9610081Socket · missingANC - DURING MAINTENANCE CHECK, ONE EMERGENCY EXIT LIGHT SOCKET WAS FOUND MISSING PALLET 9-6. REPLACED SOCKET AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9610059Door · out of adjustSEA - FLT NR 64 - L1 DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED UPPER HINGE GUIDE ARM, LUBRICATED UPPER AND LOWER HINGE FITTINGS AND ALL LATCH CAM ROLLERS. DOOR OPERATED NORMALLY. (M)SDR ASAA9610047Nlg Module · defectiveOTZ - FLT NR 52 - ON DEPARTURE FROM OTZ, NOSE LANDING GEAR WOULD NOT RETRACT. SLOWED TO 140 KNOTS, CYCLED GEAR AND NOSE GEAR CAME UP. NORMAL INDICATION FOR REMAINDER OF FLIGHT AND AIRCRAFT LANDED IN ANC WITHOUT INCIDENT. REPLACED NOSE LANDING GEAR MODULE, CSDR ASAA9610039Battery · dischargedSEA - DURING CREW PREFLIGHT, THE CREW REPORTED THAT THE EMERGENCY EXIT LIGHTS ILLUMINATED AT ROW 18. REMOVED AND REPLACED BATTERY AND LIGHTS OPERATED NORMALLY. (W)SDR ASAA9610018Battery Pack · dischargedSEA - DURING MAINTENANCE CEHCK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE ROW 2 (PALLET 1-7). REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9610015Wire · disconnectedSEA - DURING MAINTENANCE CHECK, TWO WHITE EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE IN THE AFT CABIN. REPAIRED FLOOR TRACK WIRING AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9610013Receiver · defectiveANC - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROW 18 WOULD NOT EXTINGUISH. REPLACED EMERGENCY EXIT LIGHT RECEIVER AT ROW 18 AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9610009Coffee Maker · smokingANC - FLT NR 23 - CREW REPORTED, AFT GALLEY COFFEE MAKER STARTED SMOKING. TURNED OFF GALLEY POWER AND SMOKE SUBSIDED. REPLACED AFT GALLEY COFFEE MAKER AND OPERATED NORMALLY, NO ODORS DETECTED. (M)SDR ASAA9510097Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT FLOOR TRACK LIGHTS AT ROWS 14 AND 15 REMAINED ILLUMINATED. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (X)SDR ASAA9510086Oven · defectiveANC - ON ARRIVAL OF FLIGHT 58, CREW REPORTED A STRONG ELECTRICAL ODOR EMINATED FROM OVEN IN FORWARD GALLEY WHILE IN USE. ODOR DISSIPATED WHEN GALLEY POWER TURNED OFF. REMOVED AND REPLACED DOUBLE OVEN IN NR 1 GALLEY AND OPERATED NORMALLY WITH NO ODORS NOTED. SDR ASAA9510070Floor Beam · corrodedSEA- DURING C-CHECK, CORROSION WAS FOUND ON THE UPPER FORWARD FLANGE OF THE FLOOR BEAM AT BS 520, RBL 9.50, 15.375 AND 20. PERFORMED INTERIM REPAIR PER EA 5310-01371 AND BOEING TELEX ASA-SEA-95-0440RR. (M)SDR ASAA9510069Floorbeam · corrodedSEA - DURING C-CHECK, CORROSION WAS FOUND ON THE UPPER FORWARD FLANGE OF THE FLOORBEAM AT BS 727B AT LBL 4.00. PERFORMED INTERIM REPAIR PER EA 5310-01365 AND BOEING TELEX ASA-SEA 950429RR. (W)SDR ASAA9510068Floorbeam · corrodedSEA - DURING C-CHECK, CORROSION WAS FOUND ON THE UPPER CHORD FLANGE OF THE FLOORBEAM AT BS 328 BETWEEN RBL 14.5 TO 60. PERFORMED INTERIM REPAIR PER EA 5310-1367 AND BOEING TELEX ASA-SEA 95-0438RR. (W)SDR ASAA9510067Governor · defectiveSEA - DURING C-CHECK, THE AFT AIRSTAIR FAILED THE EMERGENCY EXTENSION TIME CHECK. REPLACED CENTRIFUGAL GOVERNOR AND OPERATED WITHIN EMERGENCY EXTENSION TIME LIMITS. (W)SDR ASAA9510060Door Seal · missingANC - FLT NR 126 - CREW REPORTED LOSS OF PRESSURIZATION DURING CRUISE, PASSENGER OXYGEN MASKS AUTOMATICALLY DEPLOYED. CREW DESCENDED AIRCRAFT TO 10,000 FEET AND SUBSEQUENTLY LANDED WITHOUT INCIDENT. FOUND A LARGE SECTION OF THE AFT LOWER CARGO DOOR SEAL MISSSDR ASAA9510058Eel Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE BULKHEAD EMERGENCY EXIT LIGHT WAS FOUND INOPERATIVE. REPLACED BATTERY PACK AND LIGHT OPERATED NORMALLY. (M)SDR ASAA9510056Eel Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, THE EMERGENCY EXIT LIGHTS AT ROW 14 WERE FOUND ON AND REMAINED ON AFTER RESETTING. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9510049Eel Battery Pack · dischargedANC - DURING MAINTENANCE CHECK, THE SEAT PALLET EMERGENCY EXIT FLOOR TRACK LIGHTS WERE FOUND INOPERATIVE. REPLACED BATTERY PACK AND LIGHTS OPERATED NORMALLY. (M)SDR ASAA9510009Rod · out of adjustSEA - FLT 61 - PRIOR TO DEPARTURE, THE CREW REPORTED L1 DOOR WAS DIFFICULT TO CLOSE. ADJUSTED UPPER DOOR HINGE ROD AND DOOR OPERATED NORMALLY. (W)SDR ASAA9610001Fan · inoperativeJNU - ON ARRIVAL OF FLIGHT 66 - CREW REPORTED, BURNING ODOR IN COCKPIT AND AIR CONDITIONING FAN CIRCUIT BREAKER TRIPPED. ODOR DISSIPATED. RELEASED PER MINIMUM EQUIPMENT LIST ITEM 21-30. SUBSEQUENTLY CONFIRMED ABNORMAL NOISE AND A BURNING ODOR WHEN FAN WAS O
Back to N730AS