N943HA, cancelled Mar 4, 2019
Service difficulty reports · 80
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 = 'N943HA' AND deregistration_id = 'N943HA-2019-03-04' 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 = 'N943HA' AND deregistration_id = 'N943HA-2019-03-04' 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 HNAA2017042500138Bulb · inoperativeF/A PANEL EMERGENCY LIGHT SWITCH NORM INDICATING BULB INOPERATIVE. R & R THE BULB.SDR HNAA2017032300094Warning Light · activatedLEFT AMBER DOOR LIGHT REMAINED ILLUMINATED AFTER GEAR RETRACTION, CYCLED GEAR IAW CHECK LIST AND LIGHT EXTINGUISHED.SDR HNAA2017022400064Actuator · out of adjustLEFT AMBER GEAR DOOR LIGHT REMAINED ON AFTER GEAR RETRACTION. ADJUSTED THE NR 1 FORWARD GEAR DOOR ACTUATOR AND OPS CHECKED GOOD.SDR HNAA2017020800049Bulb · burned outEMERGENCY LIGHTS INOPERATIVE. REMOVED & REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2017020800048Bulb · inoperativePAX DOOR EMERGENCY LIGHT DIM. REMOVED & REPLACED THE BULBS, OPS CHECKED GOOD.SDR HNAA2017011600018Bulb · inoperativeEMERGENCY LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR HNAA2016121300388Battery Pack · inoperativeEMERGENCY CEILING LIGHT AT ROW 4 INOPERATIVE. R & R THE BATTERY AT ROW 3AC IAW 33-51-00.SDR HNAA2016042700123Battery Pack · dischargedSEVERAL EMERGENCY LIGHTS OUT DUE TO SWITCH LEFT ON. R & R EMERGENCY LIGHT BATTERIES IAW W/C 33-50-05R.SDR HNAA2016042100111Plate · corrodedPASSENGER DOOR AFT GOOSE NECK HARDWARE RENTION PLATE BADLY CORRODED, LOCATED ADJACENT TO TOP STEP 12668. FABRICATED PLATE AND R & R PAX DOOR AFT GOOSE NECK HARDWARE RETENTION PLATE IAW DWG 85210303, PART INSTALLED.SDR HNAA2015110400324Bulb · inoperativeFORWARD LT FUSELAGE EMERGENCY LIGHT IS INOPERATIVE. R & R BULB, OPS CHECKED GOOD.SDR HNAA2015092300284Bulb · inoperativeROW 9DF FLOOR EMERGENCY LIGHT IS OUT. REMOVED LENS, R & R ROW 9DF FLOOR EMERGENCY LIGHT, RESECURED LENS WITH RETAINED HARDWARE.SDR HNAA2015090200269Unknown · unknownEMERGENCY LIGHTS IN THE CABIN AND BOTH INTAKE BYPASS AMBER LIGHTS FLICKERING IN FLIGHT. ONLY WITH BOTH PROPELER RPM AT 1050. PROPELLER HEAT WAS OFF. CLEANED BOTH A/C GENERATOR CONNECTOR PLUGS. GROUND RAN A/C AT 1050-1200 WITH NO DEFECTS NOTED. OK FOR SERVISDR HNAA2015082100260Bulb · dimDIM LT AFT FUSELAGE EMERGENCY LIGHT. R & R BULB FOR LT AFT FUSELAGE LIGHT. OPS CHECKED GOOD.SDR HNAA2015070600213Warning Light · illuminatedRIGHT AC BUSS AND RT TRU ILLUMINATED DURING FLIGHT. R & R NR 2 AC GENERATOR IAW WORK CARD 24-20-11R. OPS CHECKED GOOD.SDR HNAA2015060100177Bulb · inoperativeMIDDLE OVERHEAD CABIN EMERGENCY EXIT LIGHT IS INOPERATIVE. R & R BULB IN OVERHEAD EMERGENCY EXIT LIGHT. OPS CHECKED GOOD.SDR HNAA2014102000294Valve · malfunctionedNR 2 OIL TEMP DROPS TO 45-50 DEGREES IN CLIMB WITH SAT OF -4 DEGREES C WITH LOW ALT SAT OF +15 DEGREES C IN CRUISE. NR 2 OIL TEMP IS 50-55 DEGREES C. RETURN TO FIELD. R & R ENGINE OIL TEMP BULB AND LEAK CHECKED, NO FIX. R & R NR 2 ENGINE OIL COOLER DIVERTESDR HNAA2014032800111Bulb · inoperativePAX DOOR FLOOR EMERGENCY LIGHT BULB IS INOPERATIVE. R & R BULB, OPS CHECKED GOOD.SDR HNAA2014022400056Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 1. R & R EMERGENCY LIGHT LAMP AT ROW 1. OPS CHECKED GOOD.SDR HNAA2014012700021Battery Pack · inoperativeEMERGENCY FLOOR LIGHTS ARE INOPERATIVE. R & R EMERGENCY LIGHT BATTERIES IAW WC 33-50-05R AND 33-50-03Q. OPS CHECKED GOOD.SDR HNAA2014010300652Controller · failedRIGHT WINDSHIELD HOT CAUTION LIGHT ILLUMINATED WITH WINDSHIELD SELECTED TO NORMAL. R & R RIGHT WINDSHIELD CONTROLLER. GROUND RAN ACFT. OPS CHECKED GOOD IAW MM 30-41-00.SDR HNAA2013060500325Bulb · inoperativeRED EMERGENCY PATHWAY LIGHT IS INOPERATIVE. R & R BULB IAW AMM 33-51-00.SDR HNAA2013051000261Transceiver · inoperativeRADAR INOPERATIVE, PAINTS INACCURATE WEATHER BEYOND 20 MILES. R & R RADAR TRANSCEIVER IAW MM 34-41-04 AND BULLETIN 34-18. OPS CHECKED GOOD. OK FOR SERVICE.SDR HNAA2013041500220Brush Block · malfunctionedEMERGENCY LIGHTS FLICKERING IN FLT (PROP HEAT OFF) F/A PANEL LIGHTING INTERMITTENT IN FLT ALSO, CLEANED AND RESEATED BRUSH BLOCKS ON NR 1 AND NR 2 ENGINES. UPPER FWD COWLING ON BOTH ENGINES REMOVED AND REINSTALLED GROUND RUN CHECK GOOD.SDR HNAA2013021900077Wire · brokenAFTER GEAR EXTENSION, CREW HEARD A SINGLE POP NOISE, THEN AFTER ROLL OUT, WHEN FLAPS WHERE SELECTED TO 5 DEGREES FROM 15 DEGREES, FLAPS DID NOT MOVE. BUT WHEN ZERO WAS SELECTED, THE FLAPS RETRACTED FULLY. MOVING FLAP SELECTOR TO ZERO, A RESISTANCE WAS FELT.SDR HNAA2013020800037Bulb · failedEMERGENCY CEILING LIGHT IS INOPERATIVE AT ROW 3. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013011400008Bulb · inoperativeSIDEWALL LIGHT IS DIM AT ROW 4DF. R & R BULB.SDR HNAA2013010701151Lamp · inoperativeEMERGENCY CEILING LIGHT AT ROW 10 IS DIM. REPLACED LAMP, INSTALLED COVER. OPS CHECKED GOOD.SDR HNAA2012112701075Actuator · leakingHYDRAULIC QTY DROPPED TO 1QT. JUST BEFORE TAKEOFF AND ISO VALVE CAUTION LIGHT ILLUMINATED. SERVICED NR 1 HYD AND OPERATED NR1 HYD SYS AND FOUND RT INBD SPOILER ACTUATOR LEAKING. R & R RT INBD SPOILER ACTUATOR IAW MM 27-14-05. OPS AND LEAKED CHECKED GOOD.SDR HNAA2012082000922Bulb · failedSECOND MOST FORWARD EMERGENCY FLOOR PATH LIGHT IS INOPERATIVE. R & R FLOOR PATH LIGHT BULB. OPS CHECKED GOOD.SDR HNAA2012071600867Bulb · failedROW 5, OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. REMOVED LIGHT LENS PANEL, R & R BULB. OPS CHECKED GOOD. INSTALLED PANEL WITH RETAINED HARDWARE.SDR HNAA2012071300858Seat Track · corrodedCORROSION ON RT INBD SEAT TRACK AROUND ATTACH POINT FOR GALLEY. REMOVED CORRODED PORTION OF SEAT TRACK IAW RD8-53-3074. SPLICE IN NEW PORTION OF SEAT TRACK IAW RD8-53-3074.SDR HNAA2012071300863Fitting · corrodedBOTTOM OF AIRSTAIR DOOR OPENING THRESHOLD FITTING IS CORRODED. R & R THRESHOLD MEMBER IAW ENG DWG 85321241.SDR HNAA2012071300862Stringer · corrodedCORROSION AT STR 31P AND FRAME X201.300 ON THE LT SIDE OF TENSION FITTING. BLENDED CORROSION IAW SRM 51-20-11, ALODINED AND PRIMED AREA IAW SRM 51-20-16 AND 51-20-36.SDR HNAA2012071300861Stringer Splice · corrodedCORROSION AT STRINGER 32S AND AFT OF FRAME 488.500. REMOVED STRINGER SPLICE AT BS 488.5. REMOVED STRINGER SECTION FROM BS 488.5 THROUGH 528. REINSTALLED STRINGER SPLICE AND STR SECTION FROM BS 488.5 TO 528 IAW DWG 85330033.SDR HNAA2012071300860Stringer · corrodedCORROSION ON STRINGER 31S BETWEEN BS 445.500 AND 467.000. BLENDED CORROSION IAW SRM 51-20-11, ALODINE AND PRIMED IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071300859Frame · corrodedMINOR CORROSION ON FRAME LEG AT BS 436.500 AND STR 31S. BLENDED CORROSION IAW SRM 51-20-11, ALODINED AND PRIMED IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071200856Frame · corrodedMINOR CORROSION AT BOTTOM OF VERTICAL FRAME MEMBER AT STA X510.00 BETWEEN STR 32S AND 31S. BLENDED CORROSION IAW SRM 51-20-11, ALODINED, PRIMED AREA IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071200855Frame · corrodedCORROSION AT FRAME LEG STA X531.5 BETWEEN STR 32S AND 31S. BLENDED CORROSION IAW SRM 51-20-11, ALODINED, PRIMED AREA IAW SRM 51-20-16, 51-20-36.SDR HNAA2012071200854Stringer · corrodedCORROSION ON STR 31S, JUST AFT OF FRAME BS 445.5.SDR HNAA2012071200850Hinge Fitting · corrodedLAVATORY SERVICE AREA DOUBLER HINGE AND DOOR ARE CORRODED. R & R LAVATORY DOUBLER AND DOOR ASSY IAW DWG 85320983.SDR HNAA2012071100849Skin · debondedSKIN DISBONDED ALONG STR 32S FROM X506 TO X520 AND AT FRAME X510 AT FRAME LEGS INBD AND OTBD OF STR 32S. REMOVED RIVETS IN FRAME X510 FROM STR 30S TO 31P, FROM STR31S TO 32S,33S AND 32P. REPAIRED SKIN DISBOND IAW EO8-53-12-0282.SDR HNAA2012051400773Wire · looseROLL SPOILER INBD HYD CAUTION LIGHT ILLUMINATED IN FLIGHT. REPLACED CONNECTOR ON INBD ROLL SPOILER HYD PRESSURE SWITCH IN NR 1 NACELLE. GROUND RAN ACFT. COULD NOT DUPLICATE ON GROUND IAW -8 WIRING MM 27-19-01 AND MM 33-12-00. ALSO FOUND LOOSE WIRE AT CONNECSDR HNAA2012040200716Relay · failedAPU FAILED AFTER RUNNING APPROX.30 MINUTES, FAULT LIGHT CAME ON FOLLOWED BY CHECK FIRE DETECT LIGHT COMING ON. APU FIRE DETECTION SYS DEACTIVATED IAW S/P APPENDIX 1 26-6. R & R RELAY 2449-K26. RAN APU. OPS CHECKED GOOD AT THIS TIME.SDR HNAA2011122300437Lamp · failedAFT EMERGENCY FLOOR PATH LIGHT IS INOPERATIVE AT ROW 9. R & R LAMP MODULE. OPS CHECKED GOOD.SDR HNAA2011090100265Lamp · inoperativeROW 4 WALL EMERGENCY LIGHTS ARE INOPERATIVE. RELAMPED ROW 4 SIDEWALL EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR HNAA2011061300171Battery · failedLEFT AFT EMERGENCY EGRESS LIGHT INOP. R & R BULB, PN 81. NO FIX. R & R EMERGENCY LIGHT BATTERY AT POSITION PS3. OPS CHECKED GOOD.SDR HNAA2011061300165Bulb · burned outROW 9 EMERGENCY FLOOR ESCAPE PATH LIGHT INOP. R & R BULB, OPS CHECKED GOOD.SDR HNAA2011021500012Light · inoperativeEMERGENCY FLOOR PATH LIGHT IS INOP AT ROW 1. R & R MARKER AS REQUIRED, OPS CHECKED.SDR HNAA20122100287Bulb · inoperativeROW 4DF AND 4AC EMERGENCY EXIT LIGHTS HAVE 1 BULB INOP. R & R BULB IN ROW 4 EMERGENCY EXIT LIGHTS. OPS CHECKED GOOD.SDR HNAA2010042300114Bulb · inoperativeEMERGENCY LIGHT BULB IN OP ON ROW 4A SIDEWALL. R & R LIGHT BULB IAW 33-51-00.
Back to N943HA, cancelled Mar 4, 2019