N314NB
Service difficulty reports · 177
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 = 'N314NB' 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 = 'N314NB' 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 DALA1118943114Floor Panel · damagedAFT CARGO COMPARTMENT, FLOOR PANEL 161NF HAS MULTIPLE DENTS, EDGE DAMAGES, CRACKS AND FILLER REPAIRS FABRICATED AFT CARGO FLOOR PANEL 161NF ON STAM TRAVELER 873413 IAW DWG 3D25-40532, MATERIAL A402AB-60X144 BATCH 1910500.SDR DALA1118933114Floor Panel · damagedAFT CARGO COMPARTMENT, FLOOR PANEL 151ZG HAS EDGE DAMAGE, DENTS, PUNCTURE AND DELAMINATION. FABRICATED AFT CARGO FLOOR PANEL 151ZG ON STAM TRAVELER T11/ 873400 IAW DWG 3D45-40532, MATERIAL A402AB-60X144 BATCH 1910500.SDR DALA1118913114Frame · corrodedAFT CABIN STR 23L BETWEEN FR70 AND FR69 HAS CORROSION IN AND UNDERSIDE OF OVAL HOLES. BLENDED AREA IAW A319 SRM 51-74-00 FOUND TO BE OUT OF LIMITS IAW A319 SRM 53-41-14. REMOVED SUPPORT FRAME IAW SRM 51-42-11. LOCATED AND DRILLED NEW SUPPORT IAW SRM 51-44-1SDR DALA1118923114Floor Support · corrodedAFT CABIN FLOOR SUPPORT -Y765 HAS 2 INCH AREA OF EXFOLIATION AT FR64 GALLEY MOUNT FASTENER HOLE AND FR 65 GALLEY MOUNT FASTENER HOLE. BLENDED AREA IAW SRM 51-74-00 ORIG MAT. .155" DAMAGE DIM. L=1.30" W=1.35" D=.050" FOUND TO BE OUT OF LIMITS IAW SRM 53-41-15.SDR DALA1118133114Floor Support · corrodedAT FRAME 12-24 Y254 FLOORBOARD SUPPORT CORRODED. BLENDED AREA IAW SRM 51-74-00 L=3.10" W=1.70 D=.049" FOUND TO BE OUT OF LIMITS IAW SRM 53-11-14 FIG 105. REMOVED FLOORBEAM IAW 51-42-11. LOCATED AND DRILLED NEW BEAM IAW SRM 51-44-11. INSTALLED NEW BEAM IAW SDR DALA1118123114Floor Support · corrodedAFT CABIN -Y465 FLOOR SUPPORT HAS 3EA AREAS OF 1 IN EXFOLIATION CORROSION BETWEEN FR 68 AND FR 69. BLENDED AREA IAW SRM 51-74-00, AREA IS L=0.5" W=.025" D=.026" FOUND TO BE OUT OF LIMITS IAW SRM 53-00-14 FIG 102. REMOVED FLOORBEAM -Y465 AFT CABIN FR 68 IAW SSDR DALA1118003114Floor Support · corrodedAT FRAME 20 - FRAME 21 Y189 DUMMY FLOORBOARD SUPPORT CORRODED. REMOVED CORROSION IAW 51-74-00 L=5.1" W=.20" D=.74" FOUND OUT OF LIMITS IAW SRM 53-11-14 FIG 105. REMOVED DUMMY RAIL AT Y185 IAW 51-42-11. LOCATED AND DRILLED NEW PART IAW SRM 51-44-11. INSTALLSDR DALA1117993114Floor Support · corrodedAT FRAME 20 Y-254 FLOORBOARD SUPPORT CORRODED. REMOVED CORROSION IAW SRM 51-74-00. FOUND OUT OF LIMITS IAW SRM 53-11-14 FIG 105. REMOVED FLOORBOARD SUPPORT FRAME IAW SRM 51-42-11. REMOVED 2EA BRACKETS FROM FLOORBOARD SUPPORT IAW SRM 51-42-11, LOCATED AND DSDR DALA1118113114Floor Support · corrodedAFT CABIN FLOOR SUPPORT Y+765 HAS 2 INCH AREA OF EXFOLIATION AROUND AND IN GALLEY MOUNT HOLE FWD OF FR 70. BLENDED AREA IAW SRM 51-74-00 L=2.25" W=1.5" D=0.080 FOUND TO BE OUT OF LIMITS IAW TRM 53-41-15. REMOVED FLOOR SUPPORT IAW SRM 51-42-11. DRILLED AND SDR DALA1118103114Floor Support · damagedAFT CABIN FLOOR SUPPORT Y+765 HAS 10 INCH LONG AREA OF SCRIBE DAMAGE WITH EXFOLIATION BETWEEN FR 66 AND FR 67. BLENDED AREA IAW SRM 51-74-00 L=6.4"W=1.5" D=0.065 FOUND TO BE OUT OF LIMITS IAW TRM 53-41-15. REMOVED FLOORBEAM IAW SRM 51-42 -11. RECEIVED NEW FSDR DALA1118093114Floor Support · corrodedCABIN FLOOR SUPPORT Y+765 HAS 6" X 3" AREA OF EXFOLIATION ABOVE FR 66. BLENDED AREA IAW SRM 51-74-00 L=4" W=2.9" D=0.087" FOUND TO BE OUT OF LIMITS IAW TRM 53-41-15. REMOVED FLOOR SUPPORT IAW SRM 51-42-11. RECEIVED NEW PART RAIL SEAT TRACK. LOCATED & DRILLSDR DALA1118083114Floor Support · corrodedAFT CABIN FLOOR SUPPORT -Y254 HAS 2 INCH AREA OF EXFOLIATION IN AND AROUND GALLEY MOUNT HOLE FWD OF FR70 BLENDED CORROSION IAW SRM 51-74-00 ORIG MAT=.071" L=1.8" W=1.3" D=.038 FOUND OUT OF LIMITS IAW SRM 53-00-14 REMOVED FLOOR SUPPORT -Y254 FROM FR68 TO FR70SDR DALA1118073114Floor Support · corrodedAT FRAME 16 Y503 DUMMY FLOORBOARD SUPPORT CORRODED. REMOVED CORROSION IAW SRM 51-74-00 L=5.1" D=.062 FOUND TO BE OUT OF LIMITS IAW SRM 53-11-14 FIG.102, REMOVED DUMMY FLOORBOARD SUPPORT IAW SRM 51-42-11, NEW DUMMY FLOORBOARD SUPPORT LOCATED & DRILLED IAW SRM SDR DALA1118063114Floor Panel · damagedAFT CABIN FLOOR PANEL 261EF HAS MISS DRILLED HOLES. FABRICATED FLOOR PANEL ON STAM TRAVELER T11/873482 IAW DWG 3D25-40640. MATERIAL 4505-374001CC-9, BATCH 1983368.SDR DALA1118053114Floor Panel · delaminatedAFT CABIN FLOOR PANEL 261PF DELAMINATED. FABRICATED FLOOR PANEL 261PF ON STAM TRAVELER T11/873409 IAW DWG 3D25-40640.MATERIAL 4505-374001CC-9, BATCH 1983368.SDR DALA1118043114Floor Panel · delaminatedAFT CABIN FLOOR PANEL 261CG DELAMINATED. FABRICATED FLOOR PANEL 261CG ON STAM TRAVELER T11/873483 IAW DWG 3D25-40640, MATERIAL 4505-374001CC-9 BATCH 1983368.SDR DALA1118033114Floor Panel · delaminatedAFT CABIN FLOOR PANEL 262HG DELAMINATED. FABRICATED FLOOR PANEL 262HG ON STAM TRAVELER T11/8732108, IAW DWG 3D25-40640, MATERIAL 4505-37400-1CC-9 BATCH 1983368.SDR DALA1118023114Floor Panel · delaminatedFWD CABIN, FLOOR PANEL 232FF HAS DELAMINATION ON LOWER SKIN AROUND SEVERAL HOLES. FABRICATED FLOOR PANEL 232FF ON STAM TRAVELER T11/873430 IAW DWG 3D25-40640.SDR DALA1118013114Floor Panel · delaminatedAFT CABIN FLOOR PANEL 261 DF DELAMINATED. FABRICATED FLOOR PANEL 261DF ON STAM TRAVELER T11/873481 IAW DWG 3D25-40640.MATERIAL 4505-37400ICC-9 BATCH 1983368.SDR DALA1117983114Stringer · corrodedFT CABIN STR 23R BETWEEN FR70 AND FR69 HAS CORROSION IN UNDERSIDE OF OVAL HOLES. BLENDED CORROSION IAW 51-74-00 AND FOUND TO BE OUT OF LIMITS IAW A319 SRM 51-41-14, L=0.010 W=0.012 D=0.018 REMOVED SUPPORT FRAME IAW A319 SRM 51-42-11, LOCATED AND DRILLED NEW SDR DALA1117053114Floor Support · damagedAFT CABIN -Y765 FLOOR SUPPORT HAS 12 INCHES LONG SCRIBE DAMAGE WITH EXFOLIATION AND 3, 1 IN AREAS OF EXFOLIATION IN AND AROUND FASTENERS BETWEEN FR66 AND FR70 BLENDED AREA IAW 51-74-00 FOUND TO BE OUT OF LIMITS IAW SRM 53-41-15. REMOVED FLOOR SUPPORT -Y765 BESDR DALA1115493114Floor Panel · corrodedAFT CABIN FLOOR PANEL 262FF CORRODED. AFT CABIN FLOOR PANEL 262FF. PANEL TO BE INSTALLED ON CARD 2500-6600. ORIG MAT .030 DAMAGE DIM L= 4.0, W= 2.0, D=.030. RETAIN FOR RECORDS.SDR DALA1115483114Floor Panel · corrodedAFT CABIN FLOOR PANEL 261FF CORRODED. AFT CABIN FLOOR PANEL 261FF PANEL TO BE INSTALLED ON CARD 2500-6602. ORIGINAL MAT.030" DAMAGE DIM L=2.5" W=2.0" D=.030".
SDR DALA1019253114Wire · damagedDURING A NON-ROUTINE CHECK, FOUND THE EMERGENCY PATH LIGHT AT ROW 11 INOP. REPAIRED WIRE AND PERFORMED FUNCTIONAL CHECK. CHECK WAS NORMAL AND ACFT RETURNED TO SERVICE.SDR DALA107673114Wire · damagedDURING A NON ROUTINE CHECK, FOUND THE EMERGENCY PATH LIGHT AT ROW 13L INOPERATIVE. MX REPAIRED WIRE AT ROW 13C AND OPS CHECK WAS NORMAL. ACFT RETURNED TO SERVICE.SDR NWAA072233114Battery Pack · inoperativeEMERGENCY ESCAPE LIGHTING SYSTEM CHECK FOUND EPSU INT LOAD LIGHT DISPLAYED. REPLACED EMERGENCY LIGHT BATTERY PACK 32-3300-4-0074, OPERATIONAL CHECK OK.SDR 0602673114Unknown · odorFLIGHT ATTENDANTS AND PASSENGERS REPORTED SMOKE ODOR IN CABIN DURING TAKEOFF. FLIGHT RETURNED TO DTW, LANDING UNEVENTFULLY. PILOTS NOTED NO ODOR IN FLIGHT DECK, APU NOT RUNNING. FLIGHT ATTENDANTS REPORTED ODOR WAS NOT FROM DEICING FLUID. CORRECTED BY BORES
Back to N314NB