N870NN
Service difficulty reports · 68
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 = 'N870NN' 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 = 'N870NN' 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 AALA202101199015Battery · faultyAIRCRAFT WAS NOT GROUNDED. AFT RIGHT INBOARD FLIGHT ATTENDANT FLASHLIGHT FLASHES RED. REPLACED BATTERY, PER AMM 25-64-00.SDR AALA2020051869001Life Raft · low pressureAIRCRAFT IN BASE MAINTENANCE: LIFE RAFT PRESSURE LOW, BELOW 3000 LBS., CENTERLINE FIRST CLASS AFT POSITION. REPLACED LIFE RAFT PER AMM 25-64-00-900-810.SDR AALA2018042049014Handle · damagedRIGHT EMERGENCY OVERWING EXIT DOOR LIFT HANDLE ASSEMBLY THAT HOUSES RED LANYARD MISSING HARDWARE. REPLACED FASTENERS IAW AMM 52-22-51, OK FOR SERVICE.SDR AALA201705289010Sign · detachedEMERGENCY EXIT SIGN ON CEILING NEXT TO EXIT ROW IS DETACHED. SECURED THE SIGN IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA20170503010Skin · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION ON EXTERIOR SKIN AT FUSELAGE STATION 797, UNDER AFT CARGO DOOR FORWARD SCUFF FLATE. REPAIRED IAW SRM 51-10-02 AND EA 269610.SDR AALA20170502010Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT RIGHT TRANSITION PANEL CORRODED BETWEEN FUSELAGE STATIONS 767 AND 787, RBL21. REMOVED AND REPLACED PANEL IAW AARD 51-00-05-1 AND DRAWING 146A8127.SDR AALA20170502009Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT RIGHT TRANSITION PANEL CORRODED BETWEEN FUSELAGE STATIONS 727F +11 AND 767, RBL21. REMOVED AND REPLACED PANEL IAW AARD 51-00-05-1, SRM 53-00-53-2R-5, AND DRAWING 146A7502.SDR AALA20170502008Transition Panel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT LEFT TRANSITION PANEL CORRODED BETWEEN FUSELAGE STATIONS 727B +7 AND 767 +11, LBL21. REMOVED AND REPLACED PANEL IAW AARD 51-00-05-1, SRM 53-00-53-2R-5, AND DRAWING 146A7502.SDR AALA20170428007Channel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. FORWARD CARGO COMPARTMENT LEFT ZEE CHANNEL SIDEPLATE CORROSION BETWEEN FLOOR PANEL SPLICES, BS 500B TO 500C, LBL24. REPAIRED IAW SRM 53-00-53-2R-5.SDR AALA20170428006Channel · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. FORWARD CARGO COMPARTMENT RIGHT ZEE CHANNEL SIDEPLATE CORROSION BETWEEN FLOOR PANEL SPLICES, FUSELAGE BS 500A TO 500F, RBL24. REPAIRED IAW SRM 53-00-53-2R-5.SDR AALA20170426002Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN FLOOR INTERCOSTAL CRACKED BETWEEN FUSELAGE STATIONS 312 AND 328, RBL31. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-00-05-1, SRM 51-40-02 AND DRAWING 141A5400.SDR AALA201704199018Cover · unsecureFWD GALLEY A/C RIGHT EMERGENCY EXIT LIGHT COVER NEEDS RESECURING. REMOVED & REPLACED LIGHT ASSY IAW MM 33-51-01 OPS CKS NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20161209010Lens · damagedCEILING EMERGENCY EXIT LIGHT AT AISLE 12ABC HAS A DAMAGED LENS. REPLACED LENS IAW AMM 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20161209009Lens · damagedCEILING EMERGENCY EXIT LIGHT AT AISLE 8ABC HAS A DAMAGED LENS. REPLACED THE LENS IAW AMM 33-51-03. OPERATIONAL CHECKED GOOD.SDR AALA20140918006Light · brokenEXIT LIGHT ASSEMBLY ATTACHED TO THE G1 GALLEY, NEXT TO THE RT NR 1 DOOR BROKEN. REPLACED LIGHT ASSEMBLY, OPERATIONS CHECKED NORMAL.SDR AALA20131217015Transfer Valve · inoperativeMIA CREW REPORTED LANDING GEAR WOULD NOT RETRACT. EMERGENCY DECLARED FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LANDING GEAR TRANSFER VLV. SYSTEM GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20130810013Pump · faultyLAX INFLIGHT DFW-SNA CREW REPORTED SYSTEM B ELECTRIC HYDRAULIC PUMP LOW PRESSURE LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED SYSTEM B ELECTRIC HYDRAULIC PUMP. SYSTEM GROUND CSDR AALA20130806007Light · inoperativeEMERGENCY LIGHT ABOVE SEAT 29DEF INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT ABOVE SEAT 29DEF. OPERATIONS CHECKED NORMAL.
Back to N870NN