N936HA, cancelled Mar 4, 2019
Service difficulty reports · 137
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 = 'N936HA' AND deregistration_id = 'N936HA-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 = 'N936HA' AND deregistration_id = 'N936HA-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 HNAA2017052200179Lens · crackedLOWER EMERGENCY EXIT LIGHT AT SEATS 1 DF HAD A CRACKED LENS AND BULBS INOPERATIVE. R & R THE BULBS AND INSTALLED NEW LENSES.SDR HNAA2017052200178Light · unsecureEMERGENCY LIGHTS AT ROW 1 ARE NOT SECURED TO THE FLOOR. FOUND THE LIGHTS BOTTOM TRACK BROKEN, REPLACED REPLACED THE LIGHT, AND INSTALLED NEW LIGHT WIRING COVER.SDR HNAA2017050400149Light · inoperativeROW 3AC CEILING LIGHT AND AFT EMERGENCY EGRESS LIGHT INOPERATIVE. R & R THE LIGHTS ASSYSDR HNAA2017041700118Bulb · burned outCABIN FLOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB. OPS CHECKED GOOD.SDR HNAA2017020100032Module · inoperativeEMERGENCY LIGHT IS INOPERATIVE AT ROW 4AC. REMOVED AND REPLACED THE LIGHT MODULE, CRIMPED THE WIRES IAW PPS 9.35. OPS CHECKED GOOD.SDR HNAA2016102800341Generator · malfunctionedIN FLIGHT, RIGHT AC BUSS CAUTION LIGHT ILLUMINATED WITH ASSOCIATED SERVICE SYSTEM FAILURE. NR 2 AC GENERATOR CAUTION LIGHT DOES NOT ILLUMINATED ON ENGINE SHUTDOWN. BULB DOES TEST. REMOVED AND REPLACED THE NR 2 AC GENERATOR IAW WORK CARD 24-20-11R.OPS AND LEASDR HNAA2016102800340Switch · malfunctionedDURING CLIMB OUT, RIGHT AC BUSS, RIGHT TRU AND RIGHT STALL WARNING CAUTION LIGHTS ILLUMINATED. CYCLED THE NR 2 AC GENERATOR SWITCH. ALL RELATED SYSTEMS OPERATE NORMALLY. GROUND RAN BOTH ENGINES. OPS CHECKED GOOD.SDR HNAA2016102400333Rotor · seizedNR 2 ENGINE FAILS TO SPOOL DURING START CYCLE. REMOVED AND REPLACED THE NR 2 STARTER GEN IAW WORK CARD 24-30-02R. NO FIX. SLAVED NR 2 DC GCU. NO FIX. FOUND NR 2 HP NOT ABLE TO ROTATE.SDR HNAA2016061000172Module · inoperativeINOPERATIVE EMERGENCY LIGHT ROW 1. R & R FIRST AND SECOND LAMP MODULE.SDR HNAA2016060800170Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT ROW 7 AND THE 2ND AND 3RD LIGHTS FROM FRONT ARE INOPERATIVE. R & R SECOND AND THIRD LIGHT ASSEMBLIES FROM FRONT, NO FIX. R & R BATTERY AT ROW 7AC, LIGHTS AT ALL 3 LOCATION PARTS INSTALLED, REMOVED 8330086, 8240485, JAX167/ORF42SDR HNAA2016051300146Light · inoperativeFIRST EMERGENCY LIGHT INOPERATIVE. R & R BULB, REINSTALLED BULB COVER AND PATH LIGHT COVER.SDR HNAA201605090137Light · inoperativeNR 2 FLOOR PATH EMERGENCY LIGHT INOPERATIVE. LIFTED UP PROTECTIVE COVER. R & R BULB, RESECURED COVER.SDR HNAA2016041200103Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE AT LEFT AFT EGRESS. R & R BULB.SDR HNAA2015120900365Bulb · inoperative5TH EMERGENCY LIGHT IS INOPERATIVE. R & R BULBS, OPS CHECKED GOOD.SDR HNAA2015111600338Bulb · inoperativeFLOOR EMERGENCY LIGHT IS OUT AT ROW 5DF. R & R BULB AT ROW 5 FLOOR EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR HNAA2015102700316Battery Pack · inoperativeLEFT AFT FUSELAGE EMERGENCY LIGHT IS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY PS3. OPS CHECKED GOOD.SDR HNAA2015102700315Bulb · inoperative9TH AND 11TH EMERGENCY LIGHT INOPERATIVE. R & R BULBS AT ROWS 9 AND 11. OPS CHECKED GOOD.SDR HNAA2015102700314Bulb · inoperativeCEILING EMERGENCY LIGHT AT ROW 7 IS INOPERATIVE. R & R BULB, OPS CHECKED GOOD.SDR HNAA2015082600264Latch · brokenRING HANDLE FOR NOSE GEAR ALTERNATE EXTENSION DOOR DETACHED. REMOVED BROKEN PORTION OF LATCH ASSY. INSTALLED NEW LATCH ASSY IAW DWG 85310006. OPS CHECKED GOOD.SDR HNAA2015082600263Uplock Sensor · malfunctionedAFTER GEAR RETRACTION AND ALL GEAR LIGHTS NORMAL, NOSE GEAR INTERMITTENTLY UNTIL GEAR WAS SELECTED DOWN. NO USUAL SOUNDS HEARD. R & R UPLOCK SENSOR ON NOSE GEAR DRAG STAY. ADJUSTED GAP AND SAFTIED IAW MM 32-52-10. CYCLED GEAR 10 TIMES, OPS CHECKED GOOD.SDR HNAA2015082100257Pseu · warning lightNOSE GEAR RED UNSAFE LIGHT ILLUMINATED FOR APPROXIMATELY 10 SECONDS WITH ASSOCIATED CLUNK. THE RED NLG LIGHT EXTINGUISHED FOR APPROXIMATELY 10 SECONDS, THEN EXTINGUISHED ON LANDING GEAR RETRACTION. NLG EXTENDED FINE. NO NOISE ON EXTENSION. INSPECTED NLG ANSDR HNAA2015080500250Indicator · malfunctionedNR 1 ENGINE OIL PRESSURE AT 70 PSI IN FLIGHT. R & R ENGINE OIL PRESSURE INDICATOR IAW 79-32-00 AND REMOVED 1 SHIM FROM NR 1 ENGINE OIL PRESSURE REGULATOR IAW MM 72-00-00. OPS CHECKED AND LEAK CHECKED GOOD IAW RUN UP MANUAL.SDR HNAA2015072200237Rod End · out of adjustLEFT MAIN GEAR DOOR ADVISORY LIGHT REMAINED ON FOR ABOUT 5 MINUTES, AFTER GEAR RETRACTED AND SELF EXTINGUISHED. ADJUST ROD END FOR FORWARD LT GEAR DOOR IAW MM 32-30-00. RETRACTED AND EXTENDED GEAR SEVERAL TIMES. OPS CHECKED GOOD.SDR HNAA2015061700194Light · inoperativeAFT EMERGENCY LIGHT IS INOPERATIVE AT ROW 9. R & R EMERGENCY LIGHT IAW 33-51-11. OPS CHECKED GOOD.SDR HNAA2015041000124Warning Light · false indicationNOSE GEAR UNSAFE RED ILLUMINATED ASSOCIATED WITH GEAR HORN SOUNDING, WHILE WAITING FOR TAKEOFF. INSPECTED NOSE GEAR DOWN LOCK SENSOR FOR DEFECTS, NO DEFECTS NOTED. CHECKED SENSOR GAPS, GAPS WITH LIMITS. PERFORMED GEAR SWINGS WITH NO DEFECTS OR ANOMALIES NOTEDSDR HNAA2014121900372Bulb · dimEMERGENCY SIDEWALL LIGHT BY PAX DOOR IS DIM. R & R BULB . OPS CHECKED GOOD.SDR HNAA2014100600282Bulb · inoperativeFLOOR EMERGENCY LIGHT IS INOPERATIVE AT ROW 2. R & R THE BULB. OPS CHECKED GOOD.SDR HNAA2014071600206Skin · damagedMULTIPLE RIVETS ARE PULLING THROUGH THE SKIN AT RT FWD SIDE OF BS 182 STRINGER 31P. REPAIRED IAW EA15-2014-151B AND EO8-53-14-0282.SDR HNAA2014040400123Garlock Seal · leakingDURING FLIGHT, AT LOW POWER SETTINGS, HOT ODOR IS EMITTED IN COCKPIT AND CABIN AT HIGH POWER SETINGS AND ON GROUND. INSPECTED BOTH ENGINE AIR SWITCHING VALVES AND APU AREA. NO DISCREPANCIES NOTED. FOUND NR 2 ENGINE GARLOCK SEAL LEAKING. R & R GARLOCK SEAL. SDR HNAA2014040400118Unknown · odorBURNING ODOR IN CABIN AT ROWS 4 AND 5. INSPECTED CABIN LIGHTING SYS AND BEHIND CABIN OVERHEAD PANELS. NO DEFECTS NOTED. GROUND RAN ACFT, NO ODOR NOTED AT THIS TIME. OK FOR SERVICE.SDR HNAA2014040200116Seal · leakingELECTRICAL ODOR WHEN BLEEDS ARE SELECTED ON. INSPECTED AND FOUND SEAL BAD IN BYPASS BLEED LINE AND MAJOR LEAK AT HEAT EXCHANGER. R & R SEALS, SECURED HEAT EXCHANGER BLEED LINE. RAN APU, NO LEAKS NOTED.SDR HNAA2014032400105Inverter · failedELECTRICAL ODOR IN COCKPIT. SECONDARY INVERTER FOUND TO BE AT FAULT.SDR HNAA2014031400087Bulb · dimLEFT OF EXTERIOR EMERGENCY LIGHT IS DIM. R & R BULB IAW AMM 33-51-00.SDR HNAA2014031400086Light · inoperativeNR 2 EMERGENCY LIGHT IS OUT. R & R NR 2 EMERGENCY LIGHT IAW AMM 33-51-11.SDR HNAA2014012000015Hydraulic System · contaminatedON CLIMBOUT, NR 1 ENGINE HYD PUMP CAUTION LIGHT ILLUMINATED, FOLLOWED BY RUDDER PRESSURE AND FULL PRESSURE CAUTION LIGHTS. NR 1 MAIN HYD PRESSURE AT 500-1K. PSI AND STANDBY AT 1.5 TO 2K PSI. DURING TAX IN NOSE WHEEL STEERING SHUT OFF. WAS ABLE TO RESET. QTYSDR HNAA2014010600660Bulb · inoperativeF/A PANEL EMERGENCY LIGHT SWITCH, BACK LIGHT INOPERATIVE WHEN LIGHTS ARE OFF. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013092300509Bulb · inoperativeRED FLOOR EMERGENCY LIGHT IS INOPERATIVE AT ROW 6DF. R & R BULB AT ROW 6DF FLOOR PATH EMERGENCY LIGHT. OPS CHECKED GOOD.SDR HNAA2013091200494Bulb · failedEMERGENCY LIGHT AT ROW 1 IS INOPERATIVE. R & R BULB. OPS CHECKED GOOD.SDR HNAA2013081900466Apu · odorSTRONG FUEL ODOR IN CABIN. GROUND RAN BOTH NR 1 AND NR 2 ENGINES, NO FUEL ODOR NOTED. VERFIED ODOR COMING FROM APU.SDR HNAA2013050100244Wheel · misinstalledBRAKES APPEAR TO BE NOT OPERATING AFTER LANDING. FOUND NR 4 MAIN WHEEL ASSY LOOSE AND INCORRECTLY INSTALLED. FOUND DAMAGE ON NR 4 AXLE. R & R SHOCK STRUT IAW WC 32-20-06F. PERFORMED HIGH SPEED TAXI. OPS CHECKED GOOD.SDR HNAA2013013000028Line · leakingIN FLIGHT, NR 1 SYS LOST HYD PRESSURE. 1/2 QT REMAINED. PRESSURE AT 3000. NR 1 HYD ISOLATION VALVE AND ROLL SPOILER INBD HYD CAUTION LIGHT ILLUMINATED. INSTALLED TEMP FLEX LINE IAW SP 20.2 FROM PRESSURE PORT OF NR 1 ENGINE DRIVEN HYD PUMP TO FIREWALL. SERVICSDR HNAA2012100901001Receptacle · burnedGROUND POWER CART PLUG CAUGHT ON FIRE AFTER BEING INSTALLED ON ACFT FOR APPROX. 40 MINUTES. FIRE DAMAGE WAS FOUND AT DC POWER RECEPTACLE AT FORWARD FRAME STA X97 AND FORWARD OF FORWARD PRESSURE BULKHEAD. ACFT IS IN MX FOR REPAIRS.SDR HNAA2012061800828Acm · failedBLUISH COLOR SMOKE IN COCKPIT. MOMENTS BEFORE SMOKE APPEARED, FELT NOTICABLE VIBRATION IN FLOOR PANEL. SHUTDOWN ENGINE AND EVACUATED ACFT. R & R ACM IAW WORKCARD 21-50-03I. OPS CHECKED GOOD.SDR HNAA2012052900803Battery · failedRT FORWARD EMERGENCY LIGHT IS DIM. R & R EMERGENCY BATTERY. REMOVING 4 BOLTS AND REINSTALLING WITH BOLTS SECURING NEW POWER SUPPLY. OPS CHECKED GOOD.SDR HNAA2012051400778Power Supply · intermittentEMERGENCY LIGHT COME ON AND THEN GO OFF AFTER A FEW SECONDS. PATH LIGHTING STAYS ON. R & R EMERGENCY LIGHT POWER SUPPLY UNIT IAW WC 33-50-05R.SDR HNAA2012051400777Battery · failedAFT CEILING AISLE EMERGENCY LIGHT AND LT AFT EMERGENCY EGRESS LIGHT ARE INOPERATIVE. R & R BATTERY ABOVE ROW 3AC. OPS CHECKED GOOD.SDR HNAA2012051400776Battery · failedLEFT FORWARD EMERGENCY EGRESS LIGHT AT AIRSTAIR DOOR IS INOP. R & R LIGHT BATTERY-TOP POSITION IN WARDROBE. OPS CHECKED GOOD.SDR HNAA2012030700671Handle · misinstalledALTERNATE STATIC SELECTOR HANDLES ARE 180 DEGRESS OUT. SWAPPER HANDLES 180 DEGREES. OK FOR SERVICE.SDR HNAA2012030200646Bracket · corrodedCENTER BRACKET OF CENTER FLOOR CORRODED. R & R WITH MADE REPAIR PART AND INSTALLED WITH BLIND RIVETS IAW SRM 51-40-00.SDR HNAA2012030200645Rod End · looseLEFT WING FLIGHT SPOILER INPUT ROD END FOUND LOOSE AND ROD WITH SURFACE CORROSION. REMOVED CORROSION FROM FLIGHT SPOILER INPUT ROD IAW MM 27-14-00. TREATED ROD WITH CORROSION PREVENTION AS REQUIRED.
Back to N936HA, cancelled Mar 4, 2019