N682BR, cancelled Sep 20, 2021
Service difficulty reports · 91
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 = 'N682BR' AND deregistration_id = 'N682BR-2021-09-20' 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 = 'N682BR' AND deregistration_id = 'N682BR-2021-09-20' 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 ASOA2013091909030Charger · inoperativeLEFT AFT OVERWING EXIT EMERGENCY LIGHT IS INOPERATIVE. R & R BATTERY PACK CHARGER.SDR ASOA2013091909029Light · inoperativeLT AFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. R & R LT OVERWING EMERGENCY LIGHT, OPS CHECKED GOOD IAW AMM 33-51-21.SDR ASOA2013091809026Charger · inoperativeEXTERNAL EMERGENCY LIGHTS ARE INOPERATIVE. R & R CHARGER ASSY IAW AMM 33-51-05.SDR ASOA2013081508870Battery · inoperativeEMERGENCY LIGHTS INOPERATIVE. R & R NR 4 BATTERY AND BATTERY CHARGER IAW AMM 33-51-04/05. OPS CHECKED IAW AMM 33-51-04-05. NO DEFCTS NOTED.SDR ASOA2013081508871Light · inoperativeCABIN EMERGENCY LIGHT CEILING 2 AND 4 INOPERATIVE.SDR ASOA2013073108812Fuse · blownRIGHT OVERWING AFT EMERGENCY LIGHT INOP. R & R NR 4 BATTERY CHARGER FUSES IAW AMM 33-51-05. OPS CHECKS GOOD IAW AMM 33-51-04,SDR ASOA2013073108811Fuse · blownLEFT OVERWING AFT EMERGENCY LIGHT INOP. R & R NR 4 BATTERY CHARGER FUSES IAW AMM 33-51-05. OPS CHECKS GOOD IAW AMM 33-51-04. PLACARD REMOVED DMIL CLEARED.SDR ASOA2013072908793Fuse · blownTWO RT WING AFT EMERGENCY LIGHTS INOPERATIVE. R & R NR 4 BATTERY CHARGER FUSES IAW AMM 33-51-05. OPS CHECKED GOOD IAW AMM 33-51-04.SDR ASOA2013072408766Charger · inoperativeNR 7 EXTERIOR EMERGENCY LIGHT INOPERATIVE. R & R BATTERY CHARGER IAW AMM 33-51-04, IPC ITEM 198A, OPS CHECKED GOOD.SDR ASOA2013071108597Fuse · blownNR 7, EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED F2 FUSE ON BATTERY PACK NR 4 IAW CMM 32-21-70. OPS CHECK GOOD.SDR ASOA2013070508575Wire · shortedNR 2 AND NR 4 CABIN CEILING LIGHTS INOPERATIVE. FOUND NR 2 CEILING LIGHT SHORTED TO GROUND. ADJUSTED RING TERMINAL. REPLACED F3 FUSE ON BATTERY PACK NR 4 IAW CMM 33-21-70. OPS CHECK GOOD.SDR ASOA2013070508574Wire · shortedEMERGENCY EXTERNAL LIGHTS INOPERATIVE. FOUND LT EXTERNAL NR 7 SOCKET TO BE GROUNDED TO ACFT. ADJUSTED WIRING. REPLACED F2 FUSE ON BATTERY PACK NR 4 IAW CMM 33-21-70.SDR ASOA2013070108546Light · inoperativeNR 2 ND 4 CABIN CEILING EMERGENCY LIGHTS INOPERATIVE. OPEN.SDR ASOA2013070108545Light · inoperativeNR 7 AND 8 EXTERNAL EMERGENCY LIGHTS INOPERATIVE. OPENSDR ASOA2013062103865Charger · inoperativeEMERGENCY LIGHT INOPERATIVE, LT & RT OVERWING AFT LIGHT, R & R NR 4 EMERGENCY LIGHT BATTERY CHARGER IAW AMM 32-51-05, OPS CHECKED GOOD.SDR ASOA2013062103864Charger · unserviceableEMERGENCY LIGHT INOPERATIVE CEILING FLOOD ROW 5 AND ROW 14. R & R NR 4 EMERGENCY LIGHT BATTERY CHARGER IAW AMM 32-51-05. OPS CHECKED GOOD.SDR ASOA2013062103860Charger · inoperativeEMERGENCY LIGHT INOPERATIVE, LT AND RT OVERWING AFT. NR 4 BATTERY CHARGER REPLACED. RT OVERWING EMERGENCY LIGHT AFT FUNCTIONS PROPERLY.SDR ASOA2013062103859Charger · inoperativeEMERGENCY LIGHTS INOPERATIVE, CEILING FLOOD AT ROWS 5 AND 14. REMOVED NR 4 EMERGENCY BATTERY CHARGER IAW AMM 33-50-05. ALL CHECKED GOOD AT THIS TIMESDR ASOA2013053003728Fuse · blownNR 4 EXTERIOR EMERGENCY LIGHTS ON LT AND RT SIDE INOPERATIVE. R & R THREE FUSES ON NR 4 BATTERY SUPPLY IAW ESPM 20-29-00. OPS CHECKED GOOD.SDR ASOA2013053003727Fuse · blownNR 2 AND NR 4 EMERGENCY CEILING FLOODLIGHTS IN CABIN INOPERATIVE. R & R THREE FUSES ON NR 4 BATTERY SUPPLY IAW ESPM 20-29-00. OPS CHECKS GOOD. DEFER CLEARED. PLACARD REMOVED.SDR ASOA2013052003624Fuse · blownNR 2 AND NR 3 CEILING EMEMERGENCY LIGHTS INOPERATIVE. REPLACED F1, F2, F3 FUSE ON NR 4 BATTER POWER SUPPLY CHARGER IAW CMM 33-21-70. OPS CHECKED GOOD.SDR ASOA2013052003623Lamp · burned outLEFT NR 4 EMERGENCY LIGHT INOPERATIVE. R & R LAMP IAW AMM 33-51-21. OPS CHECKED GOOD.SDR ASOA2013051303509Light · inoperativeAFT EMERGENCY CEILING FLOODLIGHT INOPERATIVE. PERFORMED OPS CHECK OF AFT EMERGENCY CEILING FLOODLIGHT IAW AMM 33-51-00.SDR ASOA2013050803479Charger · inoperativeAFT LT AND RT OVERWING EXTERIOR LIGHTS INOPERATIVE. R & R EMERGENCY LIGHT BATTERY CHARGER ASSY NR 4 CEILING PANEL BETWEEN FS559.00+48.00R AND FS 559.00+64.00R IAW AMM 33-51-05. OPS CHECKED OK.SDR ASOA2013050803478Charger · inoperativeEMERGENCY CEILING LIGHT AT ROW 4 INOPERATIVE. R & R EMERGENCY LIGHT BATTERY CHARGER ASSY NR 4 CEILING PANEL BETWEEN FS 559.00+48.00R AND FS 559.00+64.00R IAW AMM 33-51-05. OPS CHECK OK.SDR ASOA2013042603448Charger · inoperativeBOTH LT AND RT AFT OVERWING EXTERIOR EMERGENCY LIGHTS INOPERATIVE. R & R LIGHT & AFT CHARGER ASSY IAW AMM 33-51-05.SDR ASOA2013042603447Charger · inoperativeNR 2 CABIN CEILING LEVEL EMERGENCY FLOOD LIGHT INOPERATIVE. R & R OVERWING EMERGENCY LIGHT & CHARGER ASSY IAW AMM 33-51-05.SDR ASOA2013021803036Skin · crackedFOUND RT FUEL ACCESS HOLE 650AB HAS MULTIPLE INDICATIONS NOTED ON LANDING INBD SIDE APPROX 6.0" IN LENGTH 80 PERCENT FSH, FAILED NDT INSPECTION. REPAIRED IAW REO 601R-57-21-030.SDR ASOA2013021803035Skin · crackedFOUND RT FUEL ACCESS HOLE 640BB HAS MULTIPLE INDICATIONS NOTED ON LANDING OTBD SIDE APPROX 2.0" IN LENGTH 50 PERCENT FSH, FAILED NDT INSPECTION. REPAIRED IAW REO 601R-57-21-030.SDR ASOA2013021803034Angle · corrodedPAX DOOR LOWER PORTION FWD AND AFT ANGLE CORRODED. REMOVED CORRODED FWD AND AFT ANGLE FROM PAX DOOR LOWER PORTION. FIT, DRILLED AND INSTALLED IAW SRM 51-42-06.SDR ASOA2013021803033Angle · crackedRT FS 621.00 TO 625.00 OBLIQUE ANGLE IS CRACKED. REMOVED CRACKED ANGLE AND INSTALLED IAW SRM 51-42-21.SDR ASOA2013021803032Seat Track · corrodedCARGO TRACK CORRODED BETWEEN FS 559+80 AND FS 559+96, RBL 9. REMOVED DAMAGED CARGO TRACK IAW SRM 51-41-04. INSTALLED A NEW CARGO TRACK 601R38779-13 IAW SRM 51-41-04.SDR ASOA2013021803031Cargo Track · corrodedCARGO TRACK SEGMENT CORRODED BETWEEN FS 559+80 AND FS 559+96, RBL 27. REMOVED DAMAGED CARGO TRACK IAW SRM 51-41-04. INSTALLED NEW CARGO TRACK SEGMENT IAW SRM 51-41-04, 601R38779-13.SDR ASOA2013021803030Seat Track · corrodedCARGO TRACK CORRODED BETWEEN FS 559+80 AND FS 559+96, LBL 27. REMOVED CORRODED CARGO TRACK. DRILLED & LOCATED AND INSTALLED NEW CARGO TRACK IAW SRM 51-41-04 & 51-40-11.SDR ASOA2013021803029Seat Track · corrodedCARGO TRACK CORRODED BETWEEN FS 559+80 AND FS 559+96, LBL 9. REMOVED DAMAGED CARGO TRACK IAW SRM 51-41-04. INSTALLED NEW CARGO TRACK IAW SRM 51-41-04.SDR ASOA2013021803028Cargo Track · corrodedCARGO TRACK CORRODED BETWEEN FS 559+112 AND FS 574, RBL 9. REMOVED CORRODED CARGO TRACK. LOCATED, DRILLED AND INSTALLED NEW CARGO TRACK IAW SRM 51-40-11 & 51-41-04.SDR ASOA2013021803027Cargo Track · corrodedCARGO TRACK CORRODED BETWEEN FS 559+112 AND FS 574, LBL 9. REMOVED CORRODED CARGO TRACK. LOCATED, DRILLED AND INSTALLED NEW CARGO TRACK IAW SRM 51-41-04 & 51-40-11.SDR ASOA2013021503025Seat Track · corrodedCARGO TRACK CORRODED BETWEEN FS 605-621, LBL 9. REMOVED CORRODED CARGO TRACK. INSTALLED NEW CARGO TRACK IAW SRM 51-41-04.SDR ASOA2013021503024Seat Track · corrodedSEAT TRACK ARE CORRODED FROM FS 364 TO 409+128 LBL 9. R & R SEAT TRACK IAW AMM 53-01-11-400-802 AND SRM 51-40-11.SDR ASOA2013021503023Seat Track · corrodedSEAT TRACK CORRODED FROM FS 364 TO 409+128 RBL 9. R & R SEAT TRACK IAW AMM 53-01-11-000-802 & 53-01-11-400-802 & SRM 51-41-04.SDR ASOA2013021503022Post · crackedINDIATIONS NOTED AT FS 409+128, VERTICAL POST AT RBL 18 WL 69.0 INBD AND OTBD CHANNELS IN RADIUS 60 PERCENT AND 55 PERCENT FULL SCREEN HEIGHT APPROX .10" LENGTH. FAILED NDT. REMOVED CRACKED VERT POST ASSY AT FS 409+128 RBL 18 IAW SRM CH 51-42-06. LOCATED, DSDR ASOA2013021503021Attach Angle · crackedFS 484 ATTACH ANGLE AT RBL 27 (RT SIDE) IS CRACKED .500 LONG. REMOVED DAMAGED ANGLE AT 484 RBL 27 IAW SRM 51-42-06 & 51-42-21. LOCATED & DRILLED NEW ANGLE IAW SRM 51-40-11. INSTALLED ANGLE IAW SRM 51-42-06 & 51-42-21.SDR ASOA2013021503020Angle · crackedREPAIR ANGLES AT FS 484, LBL 36 IS CRACKED 1.00 LONG. REPAIRED INTERCOSTAL ANGLE IAW REO 601R-53-41-059.SDR ASOA2013021503019Attach Angle · crackedFS 484 ATTACH ANGLE AT LBL 27 (LT ONE) IS CRACKED .500 LONG. REMOVED DAMAGED ANGLE AT LBL 27 IAW SRM 51-42-06 & 51-42-21. LOCATED & DRILLED NEW ANDLE IAW SRM 51-40-11. INSTALLED NEW ANGLE IAW SRM 51-42-06 & 51-42-21.SDR ASOA2013021503018Angle · crackedREPAIR ANGLE AT FS 484 RBL 36 IS CRACKED 1.00 LONG. REMOVED DAMAGED ANGLES & REPAIRED INTERCOSTALS IAW REO 601R-53-41-059.SDR ASOA2012101702356Bulb · burned outLT FWD OVERWING EMERGENCY LIGHT IS INOPERATIVE. REMOVED BULB AND INSTALLED A NEW BULB IN THE LT FWD OVERWING EMERGENCY LIGHT IAW AMM 33-51-21.SDR ASOA2012082402094Battery · inoperativeALL EMERGENCY LIGHTS FOR NR 1 BATTERY POSITION ARE INOPERATIVE. R & R NR 1 EMERGENCY LIGHT BATTERY IAW AMM 33-51-04, OP'S CHECKED GOOD,SDR ASOA2012071301903Battery Pack · dischargedEMERGENCY LIGHT WON`T TEST. CHARGED EMERGENCY LIGHTS OPS CHECKED OK IAW AMM 33-50-00.SDR ASOA2012070501860Torque Link · unserviceableGEAR DISAGREE MESSAGE AFTER TAKE OFF, EMERGENCY DECLARED, ACFT RETURNED TO DEPARTURE. R & R TORQUE LINKS.SDR ASOA2012062501822Lamp · burned out3RD CEILING EMERGENCY LIGHT INOP. RELAMPED 3RD CEILING EMERGENCY LIGHT IAW AM 33-51-16. OPS CHECK GOOD. RELAMPED 3RD CEILING EMERGENCY LIGHT IAW AM 33-51-16. OPS CHECK GOOD.
Back to N682BR, cancelled Sep 20, 2021