N937HA, cancelled Mar 4, 2019
Service difficulty reports · 123
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 = 'N937HA' AND deregistration_id = 'N937HA-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 = 'N937HA' AND deregistration_id = 'N937HA-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 HNAA2017073100254Light · inoperativeTHE THIRD RED AFT EMERGENCY AISLE LIGHT IS INOPERATIVE.SDR HNAA2017062500217Bulb · inoperativeEXIT EMERGENCY LIGHT AT ROWS 1,4,5 INOPERATIVE. R & R THE BULBS. GOOD FOR SERVICESDR HNAA2017060900201Bulb · inoperativeFIRST AND 14TH EMERGENCY LIGHTS INOPERATIVE. R & R THE BULBS.SDR HNAA2017042500146Bulb · inoperativeGREEN LIGHT ON EMERGENCY LIGHT SWITCH AT FLIGHT ATTENDANT PANEL INOPERATIVE. R & R THE BULB.SDR HNAA2017041000113Bulb · inoperativeROW 2 EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR HNAA2017040500109Bulb · inoperativeROW 8DF EMERGENCY LIGHT INOPERATIVE. R & R THE BULB.SDR HNAA2017030800079Outflow Valve · dirtyAIRCRAFT WILL NOT PRESSURIZE IN AUTO OR MANUAL. CLEANED OUTFLOW VALVE IAW MM 21-30-00. OPS CHECKED GOOD. OK FOR SERVICE.SDR HNAA2016121900341Unknown · malfunctionedFIRST AND THIRD FORWARD MOST EMERGENCY FLOOR LIGHTS ARE OUT. CYCLED EMERGENCY LIGHT SWITCH. BOTH EMERGENCY FLOOR LIGHTS OPERATED FORMAL AT THIS TIME.SDR HNAA2016102400328Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE AT ROW 4. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR HNAA2016080400239Light · inoperativeMOST AFT, JUST FWD OF ROW 8DF AND 2ND FROM FRONT EMERGENCY ESCAPE FLOOR LIGHTS INOPERATIVE. R & R EMERGENCY ESCAPE PATH FLOOR LIGHT BULBS AT SAID LOCATIONS BY LIFTING LIGHT COVERS, R & R BULBS AND RESECURING COVERS.SDR HNAA2016050900138Proximity Sensor · malfunctionedRED NOSE GEAR UNSAFE LIGHT ILLUMINATED DURING CRUISE ALTITUDE OF 9,000 FT. ALSO, HEARD A THUD FROM NOSE GEAR AREA. GEAR HANDLE LIGHTS ALSO ILLUMINATED, WHILE NOSE GEAR RED LIGHT WAS ON. USED ALTERNATE EXTENSION IAW CHECKLIST. GEAR DOWN AND LOCKED. R & R NLGSDR HNAA2016042900125Pseu · malfunctionedAT 4000 FT, A THUD WAS HEARD IN COCKPIT AND NOSE AREA. LANDING GEAR UNSAFE LIGHT AND GEAR HANDLE LT ILLUMINATED CREW RETURNED TO FIELD WITH ALTERNATE EXTENSION IAW CHECKLIST GEAR DOWN AND LOCKED. NOT ABORTED BUT AIR TURNBACK. AFTER MAINTENANCE X CONTROL INSSDR HNAA2016022900061Unknown · odorWHEN APU BLEED IS SELECTED ON, THE CABIN FILLS WITH FUMES AND HAS A SWEET ODOR. MAINTENANCE INSPECTED FOUND APU OIL LEAK. P/C C/B N-8 ON RT MAIN BUS. AUXILIARY POWER UNIT FACT 27FEB16 18:15 MDT GROUND RAN APU FOR 1.5 HRS WAITING FOR PUSHBACK. NO SIGNIFICANTSDR HNAA2015110900331Battery Pack · inoperativeEMERGENCY LIGHTS ON RT AFT FUSELAGE AND 2 CEILING LIGHTS ARE INOPERATIVE. R & R EMERGENCY LIGHT BATTERY AT PS2 IAW WC 33-50-05. OPS CHECKED GOOD.SDR HNAA2015110900330Battery Pack · inoperativeRIGHT FORWARD EMERGENCY EXIT SIGN AND FORWARD CEILING LIGHTS ARE INOPERATIVE. R & R EMERGENCY LIGHT BATTERY. OPS CHECKED GOOD.SDR HNAA2015083100268Warning Light · false activationLEFT AND RT MAIN GEAR DOOR AMBER LIGHT STAYED ON AFTER GEAR RETRACTION ON MISSED APPROACH AT HHH. DID NOT EXCEED 140KT. GEAR DOORS REMAINED ON FOR REMAINDER OF FLIGHT. JACKED ACFT, SWUNG GEAR SEVERAL TIMES, COULD NOT DUPLICATE. R & R PSEU AND TIME DELAY RESDR HNAA2015082100258Battery Pack · malfunctionedFLOOR EMERGENCY LIGHTS AND EMERGENCY SIDE WALL LIGHTS FLICKER WHEN SELECTED ON. R & R EMERGENCY LIGHT BATTERIES IAW WORK CARD 33-50-05R. OPS CHECKED GOOD IAW WORK CARD 33-50-03Q. OK FOR SERVICE.SDR HNAA2014082900252Door Frame · corrodedCORROSION AT LAVATORY SERVICE DOOR OPENING A INBD EDGE. REPAIRED IAW RD8-53-2103. COMPLIED WITH EDDY CURRENT INSPECTION. NO CRACKS NOTED.SDR HNAA2014072300212Brake Assy · unknownACFT WOULD NOT MOVE WITH PARKING BRAKE DISENGAGED. R & R NR 1 AND NR 2 BRAKE AND WHEEL ASSY IAW WC 32-10-03L AND 32-42-11X. OPS CHECKED GOOD.SDR HNAA2014071100201Arm · out of adjustAFTER TAKEOFF, LEFT INBD ROLL SPOILER WOULD NOT RETRACT. ACFT RETURNED TO DEPARTURE. FOUND POTENTIOMETER ARM OVER-CENTER. ADJUSTED ARM IAW MM 27-05-11. REINSTALLED PANEL 532BB, OPS CHECKED GOOD AT THIS TIME. REVERIFIED LT INBD SPOILER FDAU READOUT IAW MSDR HNAA2014070700197Battery Pack · inoperativeOVERHEAD EMERGENCY EXIT SIGN IS INOPERATIVE AT ROW 4. R & R EMERGENCY LIGHT BATTERY PACK ABOVE ROW 7DF IAW MM 33-51-00.SDR HNAA2014052900167Sign · unsecureROW 4 AC SIDEWALL EMERGENCY EXIT SIGN UNSECURE. SECURED EMERGENCY EXIT SIGN AT ROW 4AC.SDR HNAA2014051600155Brake Assy · malfunctionedDURING TAXI, WHEN BRAKES WERE APPLIED, ACFT SHOOK AND SHUTTERED. SEEMED TO BE FROM LT BRAKE ASSY WITH AND WITHOUT ANTI-SKID ON. R & R BRAKE ASSY. OPS CHECKED GOOD IAW WC 32-10-03I AND 32-42-11X.SDR HNAA2014031000083Unknown · odorVERY STRONG ODOR OF EXHAUST FUMES IN COCKPIT, ESPECIALLY AT LOWER POWER SETTINGS WITH POWER LEVERS AT FLIGHT IDLE, ODOR GETS WORSE. GROUND RAN ACFT. ODOR IS ONLY PRESENT WITH ENGINE BLEEDS ON. OK WITH BLEEDS OFF.SDR HNAA2013122300630Bulb · dimLEFT AFT FUSELAGE EMERGENCY LIGHT IS DIM. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013102500548Relay · warning lightRIGHT BUSS CAUTION LIGHT CAME ON IN FLIGHT FOLLOWED BY RT TRU, RT ELEVATOR HORN HEAT AND RT STALL WARNING CAUTION LIGHTS. CYCLES BOTH GENERATOR SWITCHES, LIGHTS CLEARED. GROUND RAN ACFT AND COULD NOT DUPLICATE. R & R UNDER VOLTAGE RELAY FOR POSITIVE MAINTENSDR HNAA2013100400525Bulb · failedCEILING EMERGENCY LIGHT SIGN IS DIM AT ROW 4. R & R BULBS IN CEILING EMERGENCY LIGHT PANEL AT ROW 4 IAW MM 33-51-00. OPS CHECKED GOOD.SDR HNAA2013100400524Bulb · failedCEILING EMERGENCY LIGHT SIGN IS DIM AT ROW 1. R & R BULBS IN CEILING EMERGENCY LIGHT SIGN IAW MM 33-51-00. OPS CHECKED GOOD.SDR HNAA2013051700291Unknown · unknownAFTER GEAR RETRACTION, THE GEAR WARNING HORN SOUNDED AND WAS MUTED. WHEN FLAPS MOVED TO ZERO, HORN SOUNDED AGAIN AND WAS MUTED. ACFT RETURNED TO DEPARTURE. EXTENTION AND LANDING WAS NORMAL. COMPLIED WITH FUNCTION CHECK OF WARNING HORN. COULD NOT DUPLICATE. SDR HNAA2013021500060Indicator · out of adjustNR 2 PROPELLER RPM AT 1225 ON TAKEOFF ROLL. ALL OTHER INDICATIONS NORMAL. ADJUSTED NR 2 SPEED TRIM SCREW 1/8 TURN COUNTER CLOCKWISE IAW MM 61-22-00. GROUND RAN ACFT. PROP SPEED WITHIN LIMITS.SDR HNAA2013010401147Unknown · malfunctionedCREW REPORTS AFTER LEVELING, AFTER DESCENT, ACFT RAN OUT OF NOSE DOWN TRIM. CHECKED LT AND RT ELEVATOR SPRING TABS AND TRIM TABS FOR TRAVELS. ALL TRAVELS ARE WITHIN LIMITS FOR AMM 27-00-00.SDR HNAA2013010401144Bulb · inoperativeFIRST EMERGENCY LIGHT IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2012121201102Monitor · failedSECONDARY BUSS REMAINS POWERED WITH ONLY BATTERIES SELECTED ON. R & R POWER MONITOR. R & R RELAY 2431-K16. OPS CHECKED GOOD AT THIS TIME.SDR HNAA2012111901061Control Box · malfunctionedEMERGENCY LIGHTS FLICKERED ON AND OFF DURING TAXI. R & R EMERGENCY LIGHTS CONTROL BOX. GROUND RAN ACFT. OPS CHECKED GOOD AT THIS TIME. OK FOR SERVICE.SDR HNAA2012042300746Wire · brokenRIGHT ELEVATOR HORN HEATER CAUTION LIGHT ILLUMINATED IN FLIGHT, IN ICING CONDITIONS, CAUTION LIGHT EXTINGUISHED AT 200 FEET WITH PLUS 11 DEGREES. R & R BROKEN MATRIX SPLICE BETWEEN 9811P33 PIN TO 3015S2. GROUND RAN IAW RUNUP MANUAL. OPS CHECKED GOOD.SDR HNAA2012041800739Shaft · corrodedSHAFT ON FORK ASSY THAT ATTACHED TO THE BOTTOM OF LOWER DOOR STRUT ASSY AFT END IS CORRODED. REMOVED SHAFT AND FORK ASSY FROM PAX DOOR STEPS. INSTALLED NEW SHAFT ON FORK ASSY.SDR HNAA2012041800738Post · corrodedLOWER END OF FORWARD POST IS CORRODED. REMOVED LOWER FORWARD POST. REMOVED LIGHT CORROSION ON LOWER END OF FORWARD POST AND INSTALLED ON PAX DOOR SHAFT ASSY.SDR HNAA2012041800736Shaft · corrodedSHAFT ON FORK ASSY THAT ATTACHES TO THE BOTTOM OF LOWER PAX DOOR STRUT ASSY IS CORRODED. REMOVED SHAFT AND FORK ASSY FROM PASSENGER DOOR STEP. INSTALLED NEW SHAFT TO FORK ASSY AND INSTALLED FORK ASSY TO LOWER STRUT ASSY.SDR HNAA2012041300732Housing · corrodedFORWARD AND AFT SHAFT BEARING HOUSING CORRODED. R & R WITH NEW HOUSING IAW MFG DWG 85210004.SDR HNAA2012041300731Support · crackedRT AFT SUPPORT LEG FOR ACM MOUNTING STRUCTURE IS CRACKED ON THE UPPER LT FLANGE. REPAIRED IAW EO8-53-12-0161.SDR HNAA2012041300730Web · crackedWEB ON TOP OF ACM SUPPORT STRUCTURE IS CRACKED AND DENTED IN SEVERAL AREAS UNDER ACM. REPAIRED IAW EO8-53-12-0161.SDR HNAA2012041300729Threshold · corrodedPASSENGER DOOR THRESHOLD IS CORRODED. R & R THRESHOLD IAW DAV DWG 85321241.SDR HNAA2012041100728Seat Track · corrodedFIVE AREAS OF CORROSION ON LT MOST OTBD SEAT TRACK IN CABIN BELOW MID EMERGENCY EXIT AT FORWARD END. COMPLIED WITH HFEC INSPECTION. NO DEFECTS NOTED. BLENDED AND ALODINED AREAS MARKED ON OTBD LT SEAT TRACK IAW RD8-53-1342.SDR HNAA2012041100727Seat Track · corrodedSEAT TRACK CORRODED IN AREA OF GALLEY AT SEVERAL SPOTS. CUT SECTION OF AFFECTED AREA OF SEAT TRACK AND INSTALLED NEW REPLACEMENT IAW EO8-53-12-0155.SDR HNAA2012041100725Frame · crackedCABIN SIDEWALL FRAME FOOT CRACKED AT BS 467 S20S. REMOVED DAMAGED PART OF FRAME FOOT IAW SRM 53-20-21. INSTALLED LOOSE ANGLE REPAIR IAW RD 8-53-4811. HFEC INSPECTION COMPLIED WITH. NO OTHER DEFECTS NOTED.SDR HNAA2012031200682Bulb · inoperativeEMERGENCY FLOOR PATH LIGHT AT ROW 5 IS INOPERATIVE. R & R EMERGENCY FLOOR PATH LIGHT BULB AT ROW 5. OPS CHECKED GOOD.SDR HNAA2011112800401Brush Block · wornDURING CLIMB RT AC BUSS C/L ILLUMINATED, ASSOCIATED WITH RT ELEVATOR HORN HEAT, RT STALL WARNING C/L, AND RT TRU C/L. OCCURRED APPROX 1 MIN AFTER SELECTING ICING SYS ON. INSPECTED NR 2 AC CONTACTOR BOX & NR 2 AC GEN. NO DEFECTS NOTED. R & R NR 2 BRUSH BLOCK SDR HNAA2011090100272Power Supply · failedAFT EMERGENCY EGRESS LIGHT INOPERATIVE ON LT SIDE OF FUSELAGE. R & R EMERGENCY LIGHTS POWER SUPPLY AT BASE PS3 LOCATION. OPS CHECKED GOOD.SDR HNAA2011090100271Light · failedROW 5 EMERGENCY FLOOR PATH LIGHT INOPERATIVE. R & R EMERGENCY FLOOR PATH LIGHT AT ROW 5. OPS CHECKED GOOD.SDR HNAA2011090100269Power Supply · failedLAST EMERGENCY CEILING LIGHT IS INOPERATIVE. R & R EMERGENCY LIGHTS POWER SUPPLY BASE AT A3 LOCATION, OPS CHECKED GOOD.
Back to N937HA, cancelled Mar 4, 2019