N639AE
Service difficulty reports · 153
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 = 'N639AE' AND registry_match = 'registration' 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 = 'N639AE' AND registry_match = 'registration' 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 SIMA20171117001Engine · smokeDURING POST FLIGHT INSPECTION, SMOKE COMING OUT OF THE NR 1 ENGINE. PERFORMED AN INSPECTION OF THE NR 1 ENGINE. NO LEAKS FOUND AT THIS TIME. ENGINE OK TO RETURN TO SERVICE IAW ETN-EM-79-015.SDR SIMA20171001001Ecu · failedSPS ADVANCE ILLUMINATED WITHOUT ICE CONDITIONS, FLAP LOW SPEED ILLUMINATED WITH SPS ADVANCE. REMOVED AND REPLACED FECU IAW AMM 27-53-02, OPS CHECKED GOOD.SDR SIMA20170106004Skin · crackedFWD FUSELAGE SKIN CRACKED. REPAIRED THE SKIN IAW ERS-CR-53MR-2541SDR SIMA20161010009Tire · failedCREW REPORTED THAT THE NR 2 TIRE HAD A THROWN TREAD FAILURE. PERFORMED TASK CARD 05-50-15-200-801-A . REMOVED AND REPLACED NUM 1 MLG TIRE IAW WORK CARD 32-700-11 ALL CHECK SGOOD A/C OK FOR SERVICE. REMOVED AND REPLACED NUM 2 MLG TIRE IAW WORK CARD 32-700-11SDR SIMA20160416002Battery · dischargedSEVERAL EMER LIGHTS INOPERATIVE. R & R NR 2 EMER BATTERY & CHARGER. OPERATIONS CHECKED GOOD IAW AMM 33-50-04. BATTERY CHARGER ASSEMBLY, PN 11-0049 & SN 18196.SDR SIMA20160412001Light · malfunctionedEMERGENCY LIGHTS AT ROWS 1 - 5 DO NOT ILLUMINATE. RESET EMER LIGHTS & OPERATIONS CHECKED GOOD IAW AMM 33-50-00.SDR SIMA20160321001Skin · dentedDURING MBV INSPECTION, A DENT WAS FOUND, BETWEEN FRAME 25 & 26, BETWEEN STRINGERS 20R & 21R. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. REPAIRED DENT IAW ERS-EM-53MR-1993. REPAIR MATERIALS, FILLER 20SDR SIMA20160320001Rib · crackedDURING MBV INSPECTION, QA FOUND A CRACK ON THE LT WING RIB 5. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. R & R LT WING RIB 5 IAW ERS-EM-57MR-592. REPAIR MATERIALS, RIB 5 PN 145-67083-601.SDR SIMA20160318001Skin · crackedDURING MBV INSPECTION, QA FOUND 3 CRACKED AT FASTENER HOLES ON FRAME 75, BETWEEN STRINGERS 1L & 3L. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. PERFORMED PERMANENT REPAIR ON CRACKED FASTENER HOLES IAW SDR SIMA20160318002Skin · crackedDURING MBV INSPECTION, QA FOUND A CRACK AT A FASTENER HOLE ON FRAME 75, BETWEEN STRINGERS 2R & 3R. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. PERFORMED PERMANENT REPAIR ON CRACK AT FASTENER HOLE IAW ESDR SIMA20160315003Spar · crackedDURING MBV INSPECTION, QA FOUND RT WING SPAR 1 LOWER LE FLANGE CRACKED AT RIB 9. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. REPAIRED RT SPAR I CRACK AT RIB 9 IAW ERS-EM-57MR-593. REPAIR MATERIALS REISDR SIMA20160306003Fitting · corrodedDURING MBV INSPECTION, QA FOUND FRAME 68 SHEAR CLIP CORRODED AT LOWER END, BETWEEN STRINGERS 15L & 16L. ACFT WAS REMOVED FROM SERVICE & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. REPAIRED IAW SRM 53-31-04 SECTION 4 F. REPAIR MATERIALS, SHEAR CLIP 145SDR SIMA20160303005Skin · dentedDURING MBV INSPECTION, A DENT WAS FOUND BETWEEN FRAME 7 & 8, BETWEEN STRINGER 13R & 15R. ACFT WAS REMOVED FROM SERVICE FOR MBV INSPECTION & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. REPAIRED DENT IAW ERS-EM-53MR-1954. REPAIR MATERIALS DOUBLER 2024T3SDR SIMA20160303004Frame · gougedDURING MBV INSPECTION, QA FOUND FRAME 70 RT SIDE GOUGED AT PREVIOUS REPAIR. ACFT WAS REMOVED FROM SERVICE & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. REPAIRED IAW ERS EM-53MR-1941. REPAIR MATERIALS, EA9394 RESIN, SS301 SHEET 0.016" THICK.SDR SIMA20160303003Skin · dentedDURING MBV INSPECTION, A DENT WAS FOUND, BETWEEN FRAME 7 & 8, BETWEEN STRINGERS 13R & 15R. ACFT WAS REMOVED FROM SERVICE & WILL BE RETURNED TO SERVICE AFTER MBV INSPECTION. REPAIRED DENT IAW ERS-EM-53MR-1954. REPAIR MATERIALS, DOUBLER 2024T3 0.040", & FILLESDR SIMA20160118004Transducer · failedDURING PNEUMATIC ANTI-ICE TEST, RECEIVED EICAS WG ANTI-ICE FAIL MSG. COMPLIED WITH AOM VOL 1 PROCEDURES & RETURNED WITHOUT INCIDENT. R & R WING ANTI-ICING ASYMMETRY PRESS TRANSDUCER IAW MM 0-11-13. OPERATIONS CHECK OF ANTI-ICING SYS GOOD IAW MM 30-00-00. SDR SIMA20151127002Actuator · malfunctionedAFTER TAKEOFF RT MLG DID NOT RETRACT. YELLOW IN TRANSIT LIGHT CAME ON & THERE WAS A SLIGHT YAW ASSOCIATED. ANTI-ICE ACCT MECH GEAR PROBLEM. FLIGHT DECLARED EMER. R & R RT MLG UNLOCKING ACTUATOR IAW AMM 32-33-09. LEAK & OPERATIONS CHECKED GOOD.SDR SIMA20150914003Tire · damagedLEFT OTBD TIRE DAMAGE? NR 1 MLG OTBD TIRE MISSING TREAD? R & R NR 1 MLG TIRE ASSEMBLY. PERFORMED BRAKE ASSEMBLY CARBON INSPECTION IAW WC 32-700-11 & 32-700-18.SDR SIMA20150806004Light · inoperativeAFT CEILING EMER LIGHT INOPERATIVE. R & R AFT CEILING EMER LIGHT BULB IAW AMM 33-50-08-000-801-A & 33-50-08-400-801-A. OPERATIONS CHECKED GOOD END.SDR SIMA20150704001Flashlight · inoperativeREAR FLASHLIGHT WILL NOT CHARGE. R & R REAR FLASHLIGHT ASSEMBLY. OPERATIONS CHECKED GOOD IAW 33-50-16.SDR SIMA20150211003Fadec · failedAT FL 350 NR 2 HAD A SUDDEN POWER LOSS OF AROUND 15 PERCENT, N1 CAME BACK TO NORMAL FEW SECONDS LATER. TROUBLESHOOT RT ENGINE AND FOUND FAULTY FADEC 2B. REMOVED AND REPLACED THE FADEC 2B IAW AMM 73-22-01. RESET FADECS AND INSPECTED LABELS IAW AMM 73-22-01-700SDR SIMA20141028006Light · inoperativeEMERGENCY LIGHT IN AFT CABIN, LAST ROW, INOPERATIVE. R & R THE LIGHT AT ROWS 17 & 18 IAW AMM 33-50-12. OPS CHECKED GOOD.SDR SIMA20141028003Flashlight · brokenFLIGHT ATTENDANT FLASHLIGHT SWITCH IS BROKEN. R & R FLIGHT ATTENDANTS FLASHLIGHT IAW AMM 33-50-16. OPERATIONAL CHECKED GOOD.SDR SIMA20140814001Light · inoperativeMAIN DOOR EMER LIGHT INOPERATIVE. R & R LAMP FOR THE MAIN DOOR LINING EMER LT IAW AMM TASKS 33-50-10-000-801-A & 33-50-10-400-801-A. OPERATIONS CHECKED GOOD.SDR SIMA20140319004Yoke · crackedRT ENG PYLON FWD YOKE CRACKED AT LOWER ENG MOUNT. R & R RT LOWER FWD YOKE IAW EO EM-54MR-386.SDR SIMA20140305041Bracket · crackedRIGHT OVERWING PANEL LOWER BRACKET NR 2 IS CRACKED. RT OVERWING PANEL LOWER BRACKET NR 2 CRACKED HAS BEEN REMOVED & REPLACED WITH SERVICEABLE NR 2 BRACKET IAW ETN-EM-53-142.SDR SIMA20140305040Bracket · crackedLEFT OVERWING PANEL LOWER BRACKET NR 2 IS CRACKED. LT OVERWING PANEL LOWER BRACKET NR 2 CRACKED HAS BEEN REMOVED & INSTALLED SERVICEABLE LT NR 2 LOWER BRACKET IAW ETN-EM-53-142.SDR SIMA20140305034Light · crackedLEFT NR 7 EMERGENCY LIGHT STRIP IS CRACKED. R & R LT NR 7 EMERGENCY LIGHT STRIP IAW AMM 33-50-12 SEE BOW 150877 FOR OPERATIONAL CHECK.SDR SIMA20140305033Light · crackedLEFT NR 1 EMERGENCY LIGHT STRIP IS CRACKED. REMOVED & ACQUIRED LT NR 1 EMERGENCY LIGHT STRIP SEE BOW 150844 FOR INSTALLATION IAW AMM 33-50-12.SDR SIMA20140305032Support Bracket · crackedRIGHT ENG STARTER CONTROL VLV OTBD SUPPORT BRACKET CRACKED. R & R RT ENG STARTER CONTROL VLV OTBD SUPPORT BRACKET IAW AMM 80-10-02.SDR SIMA20140305031Fitting · crackedSHEAR CLIP CRACKED ON FRAME 26 BETWEEN STRINGERS 15R - 16R. R & R SHEAR CLIP AT FRAME 26, BETWEEN STRINGER 15R & 16R IAW SRM 51-40-02.SDR SIMA20140305030Fitting · crackedSHEAR CLIP CRACKED ON FRAME 24 BETWEEN STRINGERS 15R - 16R. R & R SHEAR CLIP ON FRAME 24, BETWEEN STRINGER 15R & 16R IAW SRM 51-40-02.SDR SIMA20140305029Seat Track · corrodedCENTER BEAM NR 1 SEAT TRACK IS CORRODED. R & R CTR BEAM NR 1 SEAT TRACK IAW AMM 53-01-06.SDR SIMA20140305028Firewall · crackedAPU FIREWALL CRACKED ON RT SIDE AT 3 O'CLOCK POSITION, REPAIR IAW EO EM-53AD-1883 PART C. FABRICATED & INSTALLED FILLER & DOUBLER FOR CRACKED RIVET HOLES & CRACK THAT WAS PREVIOUSLY STOP DRILLED AT THE 3 O'CLOCK POSITION ON THE APU FIREWALL IAW AMM 53-32-13, SDR SIMA20140305027Wire · brokenLEFT NR 2 EMERGENCY LIGHT STRIP WIRE UNDER FLOOR IS BROKEN. REPAIRED LT NR 2 EMERGENCY LIGHT STRIP WIRE UNDER FLOOR IAW SWPM 20-21-00 STEP 5 & WM 20-00-03. REFER TO BOW 150877 FOR OPERATIONS CHECK.SDR SIMA20140305026Fitting · crackedFRAME 73 SHEAR CLIP BETWEEN STRINGER 8L & 10L CRACKED. R & R FRAME 73 SHEAR CLIP BETWEEN STRINGER 8L & 10L IAW SRM 53-31-04.SDR SIMA20140305025Support Bracket · crackedRIGHT OVERWING FAIRING UPPER ATTACHMENT FLANGE SUPPORT BRACKET BETWEEN FRAME 48 & 49 CRACKED. R & R RT OVERWING FAIRING UPPER ATTACHMENT FLANGE SUPPORT BRACKET BETWEEN FRAME 48 & 49 IAW SRM 51-40-02.SDR SIMA20140305024Structure · corrodedBAGGAGE DOOR LOWER NUTPLATE HOLES HAVE SURFACE CORROSION. REPAIRED BAGGAGE DOOR LOWER NUTPLATE HOLES IAW ERS-EM-5200-104.SDR SIMA20140305037Sill · corrodedRIGHT CARGO FLOOR SILL IS CORRODED FWD OF FRAME 61 & LAVATORY CARBON BEAM. R & R RT FLOOR SILL AT FRAME 61 IAW SRM 51-40-02.SDR SIMA20140305035Support Angle · crackedCARGO DOOR CUT OUT RAMP SUPPORT ANGLE AT FRAME 66 CRACKED. REMOVED & INSTALLED NEW CARGO DOOR CUT OUT RAMP SUPPORT ANGLE AT FRAME 66 IAW SRM 51-40-02.SDR SIMA20140305038Sill · corrodedLEFT CARGO FLOOR SILL IS CORRODED FWD OF FRAME 61 & LAVATORY CARBON BEAM. R & R LT CARGO FLOOR SILL FWD OF FRAME 61 IAW SRM 51-40-02.SDR SIMA20140305036Support · crackedCARGO UNDERFLOOR LT BLEED AIR TUBE SUPPORT BETWEEN FRAME 68 & 69 CRACKED. REMOVED & INSTALLED LT BLEED AIR TUBES UNDER & ABOVE BLEED AIR TUBE SUPPORT BETWEEN FRAME 66 & 69 IAW AMM 36-11-09, LEAK CHECKED GOOD.SDR SIMA20140305039Gusset · corrodedLAVATORY CTR BEAM GUSSET IS CORRODED AT CARBON CTR BEAM. R & R LAVATORY CTR BEAM GUSSET IAW SRM 51-40-02.SDR SIMA20140105014Warning System · faultyDURING TAKEOFF ROLL WE HAD A NO TAKEOFF CONFIG WARNING ON EICAS WITH NO AURAL WARNING. TAKEOFF OK WAS HEARD PRIOR TO TAKEOFF & AFTER ABORTED TAKEOFF. R & R RELAY K0212 IAW AMM 20-13-02. R & R AURAL WARNING UNIT IAW AMM 31-51-01. OPERATIONS CHECKED IAW AMMSDR SIMA20131222006Mechanism · lack of lubeDURING MAINTENANCE INSPECTION ON FLIGHT 3496 FOUND MAIN CABIN DOOR HARD TO OPEN. LUBRICATED MAIN CABIN ENTRY DOOR MECHANISM IAW AMM 52-18-00, OPERATIONS CHECKED GOOD.SDR SIMA20131220007Pump · failedAFTER TAKEOFF HAD ENG 1 LOW PRESS INDICATION. THE RELAY COULD BE HEARD BEHIND CAPTAIN SEAT GOING ON & OFF CONSTANTLY. PROBLEM WAS FOUND WHEN USING PUMP 1B ON NR 1 ENG. AIRCRAFT WAS REMOVED FROM SERVICE. R&R FUEL PUMP 1B IAW EMB 145 AMM 28-21-01. OPC AND LSDR SIMA20131020001Flashlight · inoperativeF/A EMERGENCY FLASHLIGHT INOPERAITVE. R & R F/A EMERGENCY FLASHLIGHT.OPS CHECKED GOOD.SDR SIMA20131015003Flashlight Assy · unsecureF/A FORWARD FLASHIGHT HOLDER IS COMING LOOSE. SECURED F/A FLASHLIGHT, AMM 20-10-05.SDR SIMA20130814010Screw · missingCREW REPORTED EMERGENCY FLASHLIGHT ASSY ABOVE F/A CHAIR WAS DETACHED FROM THE WALL. INSTALLED MISSING SCREW IN FLASHLIGHT ASSEMBLY. IAW AMM 20-00-00. ACFT RETURNED TO SERVICE.SDR SIMA20130812002Lamp · inoperativeLEFT OVERWING EMERGENCY LIGHT INOPERATIVE. R & R LAMP IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A, OPS CHECKED GOOD.
Back to N639AE