N75994, cancelled Jun 26, 2014
Service difficulty reports · 142
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 = 'N75994' AND deregistration_id = 'N75994-2014-06-26' 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 = 'N75994' AND deregistration_id = 'N75994-2014-06-26' 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 MASA2013080875299Battery Pack · inoperativeRT OVERWING EMERGENCY LIGHT INOPERATIVE, R & R BATTERY & CHARGER ASSY. OPS CHECKED GOOD, NO FURTHER DEFECTS.SDR MASA2013061054276Structure · damagedCARGO BAY FIRE BLOCK MATERIAL DAMAGED. REMOVED AND REPLACED RT LOWER PORTION OF FIRE BLOCKING MATERIAL.SDR MASA2013061054273Connector · unsecureFLOOR EMERGENCY LIGHT INOPERATIVE AT ROW 7. SECURED CONNECTOR AND R&R LENS COVER. OPS CHECKED GOOD.SDR MASA2013061054272Battery · inoperativeF/O FLASHLIGHT INOPERATUVE. R&R BATTERY, OPS CHECKED GOOD.SDR MASA2013060754277Lamp · inoperativeLEFT FWD EMERGENCY LIGHT INOPERATIVE REPLACED LAMP, OPS CHECKED GOOD.SDR MASA2013040752474Charger · inoperativeCEILING EMERGENCY LIGHTS INOPERATIVE UPON POST FLIGHT INSPECTION. MAINTENANCE REPLACED THE BATTERY CHARGER AND FUSES FOR THE CEILING EMERGENCY LIGHTS.SDR MASA2013032952460Charger · inoperativeRIGHT AFT OVERWING EMERGENCY EXT LIGHT INOPERATIVE. REMOVED AND REPLACED CHARGER TO BATTERY PACK NR 4.SDR MASA2013032552456Battery · dischargedF/O FLASHLIGHT INOP. REMOVED AND REPLACED F/O FLASHLIGHT BATTERY.SDR MASA2012121652356Flashlight · inoperativeCAPTAIN'S FLASHLIGHT INOPERATIVE UPON PRE FLIGHT INSPECTION. REPLACED FLASHLIGHT.SDR MASA2012100825219Battery Pack · inoperativeBOTH EXTERIOR AFT EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED NR 4 EMERGENCY LIGHT BATTERY PACK.SDR MASA2012090125084Flashlight · inoperativeAFT FLIGHT ATTENDANT FLASHLIGHT INOP. PLACED ON MELSDR MASA2012081335034Engine · failedLEFT ENGINE WAS SHUT DOWN DUE TO HIGH ITT AND LOW OIL PRESS WARNING. THIS EVENT HAPPENED WHILE CLIMBING THROUGH 6000 FEET. THERE WAS SMOKE IN THE COCKPIT GENERATED BY THE EVENT. THE SMOKE DISSAPATED WHEN THE ENGINE WAS SECURED. THE AIRCRAFT RETURNED TO FIESDR MASA2012070834972Control Valve · malfunctionedAPU FIRE WARNING WITH AUTO SHUTDOWN IN FLIGHT. REMOVED AND REPLACED, APU LCV, OPS CHECKED GOOD ON GROUND.SDR MASA2012061934908Placard · missingPASSENGER DOOR PLACARD MISSING. REMOVED AND REPLACED PASSENGER DOOR PLACARD.SDR MASA2012032634616Priority Valve · faultyAFTER TAKEOFF NOSE GEAR DID NOT RETRACT. RTF/EMERGENCY DECLARED. R2 PRIORITY VALVE.SDR MASA2012032534609Selector Valve · malfunctionedDIVERTED AND DECLARED AN EMERGENCY DUE TO A GEAR DISAGREE. REPLACED NLG SELECTOR VALVE.SDR MASA2012030534531Light · inoperativeLEFT FWD EMERG LIGHT INOP. RELAMPED OPS CHECKS GOOD.SDR MASA2012011164345Light · inoperativeNR 3 CEILING EMER LIGHT INOP. R2 NR 3 CEILING EMER LIGHT.SDR MASA2012011164344Light · inoperativeRIGHT FWD EXT EMERGENCY LIGHT INOP. R2 RIGHT FWD EXT EMERGENCY LIGHT.SDR MASA2011120664157Floor Support · crackedFLOOR SUPPORT STRUCTURE CRACKED AT FS 280. PERMANENT REPAIR COMPLIED WITH PER RO CRJ-53-2535.SDR MASA2011120664156Fitting · crackedFS 621 CLIP CRACKED AT STR 14. PERMANENT REPAIR DONE PER RO CRJ-53-2537 AND CRJ SRM 51-25-06, 51-25-16, 51-25-11.SDR MASA2011120664155Bulkhead · crackedFS 621 AFT PRESSURE BULKHEAD DENTED AND POSSIBLY CRACKED BETWEEN LBL 9.00 AND 18.00 3 INCHES ABOVE CARGO FLOOR. PERMANENT REPAIR COMPLIED WITH BY PEMCO ON RO CRJ -53-2534 LOCATION - FS 621 BETWEEN LBL 9.00 AND 18.00 3 INCHES ABOVE FLOOR.SDR MASA2011120664154Skin · crackedCRACK FOUND AT WS 148.019 ON RIGHT WING LWR WING PLANK, IN THE AREA OF REAR SPAR. PERMANENT REPAIR COMPLIED WITH ON RO CRJ-57-2940.SDR MASA2011120664153Beam · crackedENGINE BOX BEAM CRACKED AT FS 640 , AFT LWR WEB; PERMANENT REPAIR COMPLIED WITH BY PER RO CRJ-53-2539.SDR MASA2011120664152Beam · crackedNDT FOR REO 601R-FS 640 FRAME BOX BEAM INTERIOR WL 119.2 HAS 2 EACH NDT VERIFIED CRACKS, AFT UPPER O/B CORNER OF INTERIOR BOX BEAM; PERMANENT REPAIR COMPLIED WITH BY PER ARO CRJ-53-25-40.SDR MASA2011120664151Fitting · crackedFS 621 RT CLIP CRACKED AT STR 14; PERMANENT REPAIR DONE BY PER MESA RO CRJ-53-2537 AND CRJ SRM 51-25-06, 51-25-16, 51-21-11, 51-42-20, 51-24-21.SDR MASA2011101163844Cable · unsecurePAX DOOR WHEEL DOES NOT RETRACT. RE-SECURED CABLE.SDR MASA2011092863768Strut · overservicedWOW ANNUNCIATOR LIGHT ON & CONFIG BRAKE. FOUND NLG STRUT OVERSERVICED. DESERVICED.SDR MASA2011091963707Light · inoperativeFWD EXTERIOR EMERGENCY LIGHT OUT. RELAMPED EMERGENCY LIGHT.SDR MASA2011091963702Door Seal · defectiveDIVERT PRESSURIZATION UNCONTROLLABLE. R2 AFT CARGO DOOR SEAL.SDR MASA2011091563690Light · inoperativePAX DOOR EMERGENCY EXIT SIGN 1 BULB INOP. RELAMPED.SDR MASA2011091563689Light · inoperativeCABIN CEILING EMERGENCY LIGHT AT 14 INOP. RELAMPED.SDR MASA2011090503621Light · inoperativeRIGHT NR 3 EMERGENCY LIGHT INOP. RELAMP RIGHT NR 3 EMERGENCY LIGHT.SDR MASA2011082903583Light · inoperativeLEFT MOST FWD OVERWING EXIT LIGHT OUT. RELAMPED OVERWING EXIT LIGHT.SDR MASA2011081803510Light · inoperativePAX DOOR EMER LIGHT INOP. R2 PAX DOOR EMER LIGHT BULBS.SDR MASA2011081503475Light · inoperativeAFT EMERGENCY LIGHT RT SIDE INOP. R2 AFT EMERGENCY LIGHT RIGHT.SDR MASA2011080803411Battery Pack · dischargedALL EMERGENCY LIGHTS FLICKERING. R2 NR 1, 2, & 3 BATTERY PACKS.SDR MASA2011080503399Light · inoperativeFWD CABIN OVERHEAD EMERGENCY LIGHT INOP. R2 LAMP ASSY.SDR MASA2011072103276Light · inoperativeRT OVERWING MIDDLE EMER LIGHT INOP. RELAMPED LIGHT.SDR MASA2011071803251Light · inoperativeRT FWD EXTERIOR EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR MASA2011071303218Lever · failedPAX DOOR ASSIST INOP. R2 AFT SWIVEL LEVER AND SUPPORT WHEEL CABLE.SDR MASA2011071103186Life Vest · missingTWO SPARE PAX LIFE VESTS MISSING. R2 PAX LIFE VESTS.SDR MASA2011062703094Light · inoperativeTWO LT EXTERIOR OVERWING EMERGENCY LIGHTS INOP. RELAMPED EMERGENCY LIGHTS.SDR MASA2011062703093Light · inoperativeLT EXTERIOR FWD EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR MASA2011062203068Transceiver · malfunctionedUNCOMMANDED GLD DEPLOYMENT ON TAXI. R2 RA TRANSCEIVER.SDR MASA2011062003065Connector · dirtyLT ENG OIL PRESSURE ICON AT ZERO CB POP. INSPECTED AND CLEANED CONNECTOR RAN ENGINES.SDR MASA2011062003057Stand Off · brokenLT JET OVERHEAT FAIL CAUTION MSG. REPOSITIONED JETPIPE LOOP STANDOFF BRACKET.SDR MASA2011061603017Light · inoperativeLT AFT OVERWING EMERGENCY LIGHT OUT. RELAMPED EMERGENCY LIGHT.SDR MASA2011061403013Light · inoperativeRT CENT EMERGENCY LIGHT INOP. R2 BULB.SDR MASA2011061302999Light · inoperativeRT FORWARD EXTERIOR EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT.
Back to N75994, cancelled Jun 26, 2014