N182UA
Service difficulty reports · 454
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 = 'N182UA' 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 = 'N182UA' 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 CALA2013080890253Light · inoperativeCABIN L4 DOOR CEILING EMERGENCY LIGHT INOPERATIVE. LIGHT REPLACED AND OPS CHECKED GOOD.SDR CALA2013080890252Light · inoperativeZONE 'B' OUTSIDE LAVATORIES 101 AND 104 EMERGENCY LIGHT FOUND INOPERATIVE. R & R EMERGENCY LIGHTS. OPS CHECKED GOOD.SDR CALA2013080890251Light · inoperativeCABIN LAVATORY 100 TWO FLOOR EMERGENCY LIGHTS FOUND INOPERATIVE. R & R EMERGENCY LIGHT ASSEMBLIES, OPS CHECKED GOOD.SDR CALA2013080890250Lamp · inoperativeRT OVERWING EMERGENCY LIGHT FWD TWO LAMPS INOPERATIVE. LIGHT ASSY REPLACED. OPS CHECK GOOD.SDR CALA2013080890249Lamp · inoperativeRT OVERWING EMERGENCY LIGHT FWD TWO LAMPS INOPERATIVE. REPLACED LAMPS AND OPS CHECKED GOOD.SDR CALA2013080890248Fuse · faultyBS 770, WL 308, EMERGENCY POWER LIGHT SUPPLY FOUND WITH NO VOLTAGE. POWER SUPPLY FUSE REPLACED AND OPS CHECKED NORMALSDR CALA2013080890242Tension Tie · crackedCRACK IN FWD TENSION TIE. REPAIRED IAW SRM 53-40-30, BS 1200.SDR CALA2013080590157Floorbeam · corrodedFLOORBEAM LOWER SURFACE CORROSION BS 1840 RBL 1 - 6. REPAIRED FLOORBEAM IAW ECRA 5300-01733. HFEC TRIMMED EDGE IAW NTM PART 6 51-00-00, PROC 23. NO CRACK FOUND.SDR CALA2013080990302Skin · crackedFWD E & E BAY DOOR EXTERIOR SKIN DENTED, BS 418, 10" BELOW S44L. HFEC, NO CRACK. FOUND WITHIN LIMITS SRM 52-40-01. SKIN REPLACED IAW SRM 51-10-02.SDR CALA2013080890241Light · inoperativeCABIN PAX SEAT 7FG OVERHEAD AISLE CEILING PANEL EMERGENCY LIGHT INOPERATIVE. OVERHEAD AISLE CEILING PANEL EMERGENCY LIGHT REPLACED AND OPS TEST NORMAL IAW AMM.SDR CALA2013080890240Fitting · crackedBS 1000, S38R, RBL 78, A CRACK FOUND AT BATH TUB FITTING INSIDE CENTER TANK DETAIL. BATH TUB FITTING BOLT HOLE CRACKED. REPLACED BATH TUB FITTING IAW SRM 51-10 -02.SDR CALA2013080590127Skin · crackedL5 DOOR AFT UPPER CUTOUT SKIN CRACKED.SDR CALA2013082290680Light · inoperativeG4 CABIN GALLEY LOWER CEILING EMERGENCY LIGHT INOPERATIVE. REPLACED EMERGENCY LIGHT PER MM, OPERATION CHECKED GOOD. P/N 0105935-0001SDR CALA2013082290679Light · inoperativeRT DOOR 2 & 3, LT DOOR 1 MOUNTED EMERGENCY LIGHT INOPERATIVE. RT DOOR 2 & 3, LT DOOR 4 REPLACED BULBS FOR DOOR MOUNTED EMERGENCY LIGHTS.SDR CALA2013082090612Bulkhead · crackedBS 1241 LBL 78 WL 170 CANTED BULKHEAD WEB FOUND CRACKED AFTER CLOSEOUT PANEL REMOVAL. REPAIRED & INSPECTED INAW NDT 51-00-00 PART 6.SDR CALA2013080590135Angle · crackedR5 DOOR FWD CUTOUT FRAME INBD ANGLE CRACKED AT S26R AT BS 2231. FRAME FWD INNER ANGLE REPAIRED.SDR UALA2013072605243Seat Track · corrodedBS 1830 - 1860 LBL 43 SEAT TRACK FLANGE CORRODED. CORROSION REMOVED IAW SRM 51-10-02, FOUND NOT WITHIN SRM ALLOWABLE DAMAGE 53-00-52, FIG 101. REPLACED SEAT TRACK. MAJOR REPAIR.SDR UALA2013072605242Floor Support · corrodedBS 1600 - 1700, RBL 40 FLOOR SUPPORT UPPER SURFACE CORRODED. REMOVED CORROSION IAW 51-10-02. FOUND OUT OF SRM 53-00-52 ALLOWABLE DMG1, FIG 101, FLOOR SUPPORT REPLACED IAW SRM 51-10-02, NEW SUPPORT INSTALLED IAW 51-40-02.SDR UALA2013072505226Angle · crackedBS 140, S20R ANGLE FOUND CRACKED. REPAIRED IAW ECRA 5300-01717, PART 1.SDR UALA2013072505225Web · crackedBS 140-160, S20R SHEAR WEB CRACKED. REPAIRED IAW ECRA 5300-01718, PART 1.SDR UALA2013072505224Frame · crackedBS 140, S20L, FOUND A CRACK IN BULKHEAD OUTER RING, CRACK LENGTH 1 INCH, AREA REPAIRED IAW ECRA 5300-01717, PART 1.SDR UALA2013072205128Reveal · crackedL5 DOOR FWD CUTOUT REVEAL CRACKED CRACK IS 1.5". AREA REPAIRED IAW SRM 53-60-15, REPAIR 3, FIG 201 AT BS 2231 BETWEEN NR 4 AND 5 STOP AREA THIS REPAIR IS A CATEGORY "B" REPAIR.SDR UALA2013071905067Reveal · crackedL2 DOOR FWD CUTOUT REVEAL CRACKED BETWEEN NR 1 AND NR 2 STOPS. REPAIRED IAW SRM 53-60-15, REPAIR 4, FIG 201, DETAIL 1.SDR UALA2013071905066Seat Track · corrodedMAIN DECK BS 1830, LBL 33, SEAT TRACK FLANGE AROUND TIE DOWN FOUND CORROSION. REPLACED SEAT TRACK IAW SRM 51-40-02. MAJOR REPAIR.SDR UALA2013071805031Seat Track · corrodedMAIN DECK, BS 1700 - 1820, RBL 43 LONGITUDINAL SEAT TRACK FLANGE FOUND CORRODED. NEW SEAT TRACK INSTALLED IAW SRM 51-40-02 AND 51-10-02.SDR UALA2013071604983Skin · crackedBS 980 AT STR 38R DRAG SPLICE FITTING FASTENER HOLE CRACKED ON SKIN. REPAIRED IAW SRM 53-20-01, REPAIR 2, FIG 201, DETAIL III, (CAT B REPAIR.) AT BS 950-1000, STR 37R TO 39R.SDR UALA2013071604982Skin · crackedBS 980 DRAG SPLICE FITTING AT STRINGER 38L, A CRACK FOUND ON SKIN UNDERNEATH FITTING AT 6:00 POSITION THROUGH SKIN THICKNESS. REPAIRED IAW SRM 53-20-01, REPAIR 2, FIG 201, DETAIL III, BS 950-1000, STR 37L TO 39L.SDR UALA2013071604981Skin · crackedSKIN AT BS 2375, STRINGER 15L FOUND CRACKED. SKIN REPAIRED IAW SRM 53-00-01, FIG 201, REPAIR 1, DETAIL 1.SDR UALA2013071604980Channel · crackedBS 1140, TENSION TIE AREA, FOUND CRACK AT FWD CHANNEL THROUGH THICKNESS. REPAIRED IAW SRM 53-40-30, REPAIR 2, FIG 201.SDR UALA2013071504905Floorbeam · deformedFLOORBEAM UPPER TEE DEFORMED BS 940, RBL 24-35. REPLACED IAW SRM 51-10-02. NEW TEE FABRICATED IAW SRM 51-40-05.SDR UALA2013071204858Web · crackedLT FLOOR WEB CRACKED. HFEC IAW NTM PART 6 51-00-00, PROC 4 AT TRIMMED AREA NO CRACK FOUND. REPAIRED CRACKED WEB IAW SRM 53-10-51, REPAIR 7, FIG 201.SDR UALA2013060503900Lamp · inoperativeON CM CHECK, 51H EMERGENCY LIGHT INOPERATIVE. REPLACED LAMPS.SDR UALA2013052003448Cover · faultyEXPOSED WIRES AND TERMINAL IN LAV 113. WIRES ARE SECURE AND INTERIM COVERED. SMALL PLASTIC COVER ON TERMINAL STRIP IS MISSING. LAV NOT TO BE USED, DOOR IS LOCKED, CLOSED. REF IPC 25-40-01-50L, ITEM 52, PN B0040107-001, PCN 181-2900.SDR UALA2013051603410Gauge · inaccurateCREW OXYGEN BOTTLE GAUGE INCORRECT. REPLACED CREW O2 BOTTLE IAW MM.SDR UALA2013043003012Control Box · malfunctionedRUDDER STIFF ON TAKEOFF. PERFORMED TROUBLESHOOTING IAW FIM AND FOUND SRL-L AT FAULT. REPLACED SRM-L AND OPS CHECKED OK. MESSAGE CLEARED.SDR UALA2013042302818Latch · brokenGALLEY BY DOOR 4 LEFT DOOR LATCH BROKEN. REPAIRED LATCH.SDR UALA2013041902723Wire · brokenSEAT 36H MOUNTED EMERGENCY LIGHT MISSING. REPLACED SEAT MOUNTED EMERGENCY LIGHT AND REPLACED CABLE FROM SEU TO EMERGENCY LIGHT DUE TO BROKEN WIRE, OPS CHECKED OKAY. PERFORMED INSPECTION.SDR UALA2013040802306Charger · faultyBATTERY CHARGER APU - APU STATUS MESSAGE. REPLACED APU BATTERY AND APU CHARGER, OPS CHECK GOOD.SDR UALA2013040302186Oxygen Bottle · low pressureONE O2 BOTTLE PRESSURE LOW AT 4R. NO TIME TO SERVICE, DF PER MEL. REPLACED O2 CYL FULL WITH MASK.SDR UALA2013032701960Light · missingTHE SEAT 35H MOUNTED EMERGENCY LIGHT MISSING. REPLACED EMERGENCY LIGHT, OPS CHECKED OKAY.SDR UALA2013032101769Restraint · inoperativeAFT CARGO RT DOOR SILL RESTRAINT INOPERATIVE. RAMP REPORTED. RELEASE PEDAL DOES NOT WORK. DOOR SILL RESTRAINT REMOVED.SDR UALA2013031401526Connector · unsecureDURING EMERGENCY LIGHT CHECK 51-52H LIGHT STRIPS DID NOT ILLUMINATE. FOUND CONNECTORS NOT SECURED. RE-SECURED CONNECTORS AND WIRING SECURE, LIGHT TEST OK.SDR UALA2013031401525Connector · unsecureTHE 57H EMERGENCY LIGHT STRIP HAS COME OFF. RE-SECURED ELECTRICAL CONNECTOR AND LIGHT STRIP. GROUND TEST OK.SDR UALA2013031401524Light · brokenTHE 56H AISLE EMERGENCY LIGHT STRIP IS BROKEN OFF. NEW LIGHT STRIP FITTED AND TESTED OKAY.SDR UALA2013021100812Feeder Cable · brokenEMERGENCY LIGHTS ON STAIRWAY INOPERATIVE. REPAIRED BROKEN FEEDER CABLE. OPS CHECKED OKAY.SDR UALA2013012800477Light · brokenSEAT 21C FLOOR EMERGENCY LIGHT BROKEN IN HALF. REPLACED EMERGENCY LIGHT AND CHECKED OKAY.SDR UALA2013010900173Connector · disconnectedFOUND EMERGENCY LIGHT ON STAIR DOES NOT ILLUMINATE. RECONNECTED CONNECTOR AND OPS CHECKED OK.SDR UALA2012112806847Access Panel · missingNR 2 ENGINE PYLON HAS ONE MISSING ACCESS PANEL FROM THE INBOARD SIDE.SDR UALA2012112606747Access Panel · missingNR 2 ENGINE PYLON HAS ONE MISSING ACCESS PANEL FROM THE INBOARD SIDE. REPLACED PANEL.SDR UALA2012111306519Strip · looseUPPER DECK FLOOR TRIM STRIP BETWEEN CARPET, AND RUBBER FLOORING, AND MAIN DECK STRIP IN FRONT OF STAIRS ARE COMING LOOSE. REPLACED TRIM RUBBER TRIM STRIP IN FRONT OF STAIRS, STILL NEED TO REPLACE STRIP IN UPPER DECK GALLEY, PART ON AOG# W2308. WORK ACCOMPLIS
Back to N182UA