N16813, cancelled Nov 13, 2002
Service difficulty reports · 98
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 = 'N16813' AND deregistration_id = 'N16813-2002-11-13' 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 = 'N16813' AND deregistration_id = 'N16813-2002-11-13' 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 CALA0100577Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS DELAMINATED AT FS 693 - 769, RIGHT I/B, LEFT I/B, AND CENTER AND FS 769 - 826, CENTER. THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100576Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS DELAMINATED FS 1113 - 1155, LEFT I/B, FS 1117 - 1174, RIGHT I/B, FS 1155 - 1212, CENTER, AND FS 1193 - 1250, RIGHT I/B. THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100575Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS DELAMINATED AT FS 1174 - 1193, RIGHT I/B, FS 1174 - 1287, LEFT O/B, FS 1212 - 1287, CENTER, AND FS 1287 - 1338, CENTER. THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100574Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS DELAMINATED AT FS 828 - 864, RIGHT I/B, AND FS 875 - 886, LEFT I/B. THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100573Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS DELAMINATED AT FS 927 - 1003, RIGHT I/B, FS 946 - 1003, CENTER, AND FS 1003 - 1079, RIGHT I/B. THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100572Floor Panel · delaminatedINSPECTION FOUND CABIN ENTRY FLOOR PANELS H&K DELAMINATED. THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100571Floor Panel · delaminatedINSPECTION FOUND COCKPIT FLOOR PANELS B,C,D,&E DELAMINATED. THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100570Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS DELAMINATED AT FS 160 - 196 (PANELS F&G) AND AT FS 196 - 256 (PANELS M,N, AND O). THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100569Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS DELAMINATED AT FS 1003 - 1079, LEFT O/B, AND FS 1250 - 1309, RIGHT I/B. THE FLOOR PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100568Floor Panel · delaminatedINSPECTION FOUND CABIN FLOOR PANELS DELAMINATED AT FS 828 - 864 (LEFT I/B), FS 864 - 886 (RIGHT I/B), AND FS 864 - 927 (RIGHT I/B). THE PANELS WERE REPLACED IAW ECRA 5320-01265.SDR CALA0100567Skin · dentedINSPECTION FOUND L/H FUSELAGE EXTERNAL SKIN DENTED AT FS 264 JUST BELOW LONGERON 23L. A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-04, FIGURE 38, 51-10-3, AND 51-30-2.SDR CALA0100564Skin · dentedINSPECTION FOUND R/H FUSELAGE SKIN DENTED AT FS 275, LONGERON 24R. THE DENTED AREA WAS REFORMED IAW SRM 51-10-2. A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-04, FIGURE 38, SHEET 22, 51-10-3, AND 51-10-2.SDR CALA0100563Web · crackedINSPECTION FOUND A 2 INCH CRACK IN MAIN CABIN CUSP WEB AT FS 1303, LBL 56. THE CRACK WAS STOP DRILLED IAW SRM 53-01, FIGURE 2. A DOUBLER REPAIR WAS INSTALLED IAW SRM 53-05, FIGURE 96, 51-10-4, 51-10-3, AND 51-30-2.SDR CALA0100562Skin · damagedINSPECTION FOUND FUSELAGE SKIN CREASED AT FS 503, LONGERON 22R. RIVETS WERE REMOVED AND THE SKIN WAS COLD FORMED IAW SRM 51-30-2 AND 53-04. A DOUBLER WAS INSTALLED IAW SRM 51-10-4, 51-10-3, AND 53-04, FIGURE 38, SHEET 22.SDR CALA0100561Floor Support · corrodedINSPECTION FOUND MAIN CABIN FLOOR SUPPORT CORRODED AT FS 1155, LBL 22-45. THE FLOOR SUPPORT WAS REMOVED AND A NEW SUPPORT WAS INSTALLED IAW SRM 51-30-2, 53-11-0, AND 51-10-3.SDR CALA0100560Web · corrodedINSPECTION FOUND MAIN CABIN CUSP WEB CORRODED UNDER PAN AT FS 140 - 160, RBL 45 - 55. THE DRAIN PAN WAS REMOVED AND THE CORRODED AREA WAS CUT OUT IAW SRM 51-30-1 AND 53-01, FIGURE 2. A DOUBLER WAS INSTALLED IAW SRM 53-14-01, 51-10-3, AND 51-30-2. THE DRAIN SDR CALA0100559Support · corrodedINSPECTION FOUND MAIN CABIN PAN SUPPORT CORRODED AT FS 148-160, RBL 54. THE SUPPORT WAS REMOVED AND A NEW SUPPORT WAS INSTALLED IAW SRM 51-30-2, 53-11, FIGURE 22, 51-10-4, AND 51-10-3.SDR CALA0100558Skin · damagedINSPECTION FOUND RT FUSELAGE EXTERNAL SKIN CREASED AT FS 351, JUST BELOW LONGERON 23R. RIVETS WERE REMOVED AND THE SKIN WAS COLD FORMED IAW SRM 51-30-2 AND 53-04, FIGURE 38. A DOUBLER WAS INSTALLED IAW SRM 53-04, FIGURE 38 AND 51-10-3.SDR CALA0100557Web · corrodedINSPECTION FOUND MAIN CABIN CUSP WEB CORRODED AT FS 200 - 218, LBL 20. THE CORRODED AREA WAS CUT OUT IAW SRM 53-01, FIGURE 1, SHEET 1. A DOUBLER WAS INSTALLED IAW SRM 53-01, FIGURE 1, 51-10-4, 51-10-3, 51-30-2, AND 51-30-8.SDR CALA0100556Skin · damagedINSPECTION FOUND RT FUSELAGE EXTERNAL SKIN CREASED AT FS 370, JUST BELOW LONGERON 19R. THE AREA WAS COLD WORKED AND A DOUBLER WAS INSTALLED IAW SRM 51-10-3 AND 53-04, FIGURE 38, SHEET 22.SDR CALA0100555Web · crackedINSPECTION FOUND A 6 INCH CRACK IN MAIN CABIN CUSP WEB AT FS 1198, LBL 56. A DOUBLER WAS INSTALLED IAW SRM 51-30-2, 53-01, FIGURE 2, AND 51-10-3.SDR CALA0100554Web · crackedINSPECTION FOUND A 4 INCH CRACK IN MAIN CABIN CUSP WEB AT FS 1245, LBL 56. THE CRACK WAS STOP DRILLED IAW SRM 53-01, FIGURE 1. A DOUBLER WAS INSTALLED IAW SRM 51-10-4, 51-10-3, 51-30-2, AND 53-01, FIGURE 1.SDR CALA0100552Floor Support · corrodedINSPECTION FOUND LT LAV WALL AND FLOOR SUPPORT CORRODED AT FS 1303 - 1338. THE FLOOR SUPPORT WAS REMOVED AND A NEW FLOOR SUPPORT WAS INSTALLED IAW SRM 51-30-1, 51-10-4, AND 51-10-3.SDR CALA0100549Skin · damagedINSPECTION FOUND LT FUSELAGE EXTERNAL SKIN CREASED FORWARD OF AOA VANE AT FS 70. A NEW DOUBLER WAS INSTALLED IAW SRM 53-01, FIGURE 2, 51-10-4, 51-10-3, AND 51-30-2.SDR CALA0100264Bungee Cylinder · defectiveWHEN GEAR WAS LOWERED FOR LANDING ON APPROACH TO ORD THREE RED UNSAFE LIGHTS WERE ILLUMINATED. A GO-AROUND WAS PERFORMED AND QRH PROCEDURES WERE ACCOMPLISHED WITH SUCCESSFUL GEAR EXTENSION. THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE TROUBLESHOOTING FSDR CALA0000029Battery · dischargedINSPECTION FOUND FORWARD UPPER AREA OF EMERGENCY PATH LIGHTS INOPERATIVE. MAINTENANCE FOUND BATTERIES FAILED IN POWER SUPPLY.. THE POWER SUPPLY WAS REPLACED IAW MM 33-53-00.SDR CALA9900803Longeron · corrodedINSPECTION FOUND LONGERON 30 CORRODED ON O/B SIDE IN FORWARD CARGO COMPARTMENT BETWEEN STA 465 AND 484. THE LONGERON SECTION WAS REPLACED IAW SRM 53-02, FIGURE 18.SDR CALA9900802Longeron · corrodedINSPECTION FOUND FORWARD CARGO COMPARTMENT LONGERON 30 CORRODED BETWEEN STA 256 AND 275. THE LONGERON SECTION WAS REMOVED AND REPLACED IAW SRM 53-02, FIGURE 14.SDR CALA9900801Skin · delaminatedINSPECTION FOUND LEFT WING NR 1 O/B SPOILER DELAMINATED. THE SPOILER WAS REMOVED AND REPLACED IAW MM 27-61-01.SDR CALA9900767Seat Track · corrodedINSPECTION FOUND LEFT O/B SEAT TRACK CORRODED FROM STA 1155 TO 1174. THE SEAT TRACK WAS REMOVED AND REPLACED IAW SRM 53-05, FIGURE 4 AND SRM 51-30-2.SDR CALA9900766Tab · dentedINSPECTION FOUND RT SIDE OF RUDDER TAB DENTED. THE TAB WAS REMOVED AND REPAIRED IAW SRM 55-04, PARAGRAPH 2. THE TAB WAS BALANCED AND REINSTALLED IAW MM 27-20-02.SDR CALA9802175Prox Sensor · inoperativeTHE RT MLG GREEN LIGHT FLICKERED WHEN GEAR WAS EXTENDED ON APPROACH TO EWR. THE EMERGENCY GEAR HANDLE WAS PULLED AND THE GREEN LIGHT ILLUMINATED STEADILY FOR A NORMAL LANDING. THE GROUND PROXIMITY SENSOR WAS CLEANED. A PROXIMITY SENSOR TEST AND EVALUATION FSDR CALA9800571Starter · failedTHE A START VALVE LIGHT ILLUMINATED AFTER TAKEOFF FROM CLE. THE LIGHT EXTINGUISHED AFTER ABOUT 30 SECONDS. ENGINE POWER WAS BEING REDUCED, CROSSFEED WAS CLOSED, AND HP BLEED WAS ON HIGH. THE FLIGHT LANDED AT EWR WITHOUT FURTHER PROBLEM. MAINTENANCE FOUND TSDR CALA9700915Bracket · crackedINSPECTION FOUND A .5 INCH CRACK IN T-FITTING BRACKET INSIDE FORWARD BAGGAGE DOOR. THE BRACKET WAS REMOVED AND REPLACED IAW SRM 51-00.SDR CALA9700914Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED IN AFT BAGGAGE COMPARTMENT AT FS 1212 BETWEEN LONGERON 29R AND 28L. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-00 AND 51-30-2.SDR CALA9700913Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED JUST INSIDE DOORWAY WEB AT FS 1155 TO 1212. THE FLOOR SUPPORT WAS REMOVED AND A REPLACEMENT SUPPORT WAS FABRICATED AND INSTALLED IAW SRM 51-30-2 AND 51-10-3.SDR CALA9700909Floor Track · corrodedINSPECTION FOUND NR 2 GALLEY OUTBOARD ATTACH FLOOR TRACK AT STA 207 CORRODED. THE CORRODED SECTION WAS REMOVED, A REPLACEMENT SECTION WAS FABRICATED AND INSTALLED IAW SRM 53-05, FIGURE 4F.SDR CALA9700920Stringer · crackedINSPECTION FOUND A 2 INCH CRACK IN STRINGER 17L AT STA 275. REPAIRED IAW SRM 53-02.SDR CALA9700919Frame · crackedINSPECTION FOUND 1/4 CRACKS AT HI-LOK FASTENERS AT CANTED BULKHEAD TO LONGERON ATTACH AREAS, FS 1446, LONGERONS 2R, 3R, AND 4R. REMOVED AND REPLACED FRAME CHORD IAW SRM 53-03.SDR CALA9700916Bulkhead Web · crackedINSPECTION FOUND THREE CRACKS IN CANTED BULKHEAD WEB AT FS 1463 BELOW LONGERON 6R IN THE AFT ACCESSORY COMPARTMENT. THE CRACKS MEASURED FROM 1 TO 2 INCHES IN LENGTH. A NEW WEB WAS FABRICATED AND INSTALLED IAW SRM 53-14-4.SDR CALA9700907Bracket · crackedINSPECTION FOUND A .25 INCH CRACK IN LT AILERON NR 4 HINGE BRACKET. THE HINGE BRACKET WAS REMOVED AND REPLACED IAW SRM 51-10-01 AND MM 27-10-0.SDR CALA9700906Rib · crackedINSPECTION FOUND A 2 INCH CRACK IN LT WING LEADING EDGE RIB AT XRS 30. THE CRACK WAS LOCATED AT FORWARD LOWER AREA BETWEEN NR 2 AND NR 3 SLAT TRACKS. THE CRACK WAS STOP DRILLED, A DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 57-01-0 AND 51-30-0.SDR CALA9700921Skin · dentedINSPECTION FOUND LT FUSELAGE SKIN DENTED AT FS 220 BETWEEN LONGERONS 18L AND 19L. THE DENTED AREA WAS CUT OUT. FILLER AND DOUBLER WERE FABRICATED AND INSTALLED IAW SRM 53-04.SDR CALA9700911Skin · dentedINSPECTION FOUND A DENT IN LT FUSELAGE SKIN AT FS 235 BETWEEN LONGERONS 18L AND 16L, ABOVE CUSP LINE. THE SKIN SECTION WAS REMOVED AND REPLACED IAW ECRA 5330-02445.SDR CALA9700910Doubler · crackedINSPECTION FOUND A .5 INCH CRACK AT UPPER CORNERS AND LOWER FORWARD CORNER OF AFT LAV SERVICE PANEL CUTOUT. THE CRACKED DOUBLERS WERE REMOVED, NEW DOUBLERS WERE FABRICATED AND INSTALLED IAW ECRA 5330-01659.SDR CALA9700908Doubler · crackedINSPECTION FOUND A .25 INCH CRACK IN DOUBLER AT CUTOUT FOR RIGHT AFT NOSE WHEEL WELL DOOR AFT HINGE. A .375 INCH CRACK WAS FOUND IN DOUBLER AT CUTOUT FOR LEFT AFT NOSE WHEEL WELL DOOR AFT HINGE. THE DOUBLERS WERE REMOVED, REPLACEMENT DOUBLERS WERE FABRICATEDSDR CALA9700551Downlock Sensor · broken wireTHE RT MLG UNSAFE LIGHT REMAINED ILLUMINATED WITH GEAR EXTENSION ON APPROACH. THE GEAR WAS CYCLED WITH NO CHANGE. A TOWER FLY-BY WAS PERFORMED AND GEAR WAS VISUALLY CONFIRMED DOWN AND LOCKED. THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND A BROKENSDR CAL960593Oil Tube · leakingMSY - FLT 1865 - THE NR 1 ENGINE BEGAN TO LOSE OIL WHILE EN ROUTE FROM PBI TO IAH. THE AIRCRAFT WAS DIVERTED TO MSY WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND A LEAKING OIL TUBE TO NR 1 ENGINE. THE OIL TUBE WAS REPLACED WITH NEW SEALS INSTALLED. T
Back to N16813, cancelled Nov 13, 2002