N865NN
Service difficulty reports · 111
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 = 'N865NN' 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 = 'N865NN' 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 AALA20161104033Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE IS CORRODED AT FUSELAGE STATIONS 727J AND 767. REMOVED AND REPLACED TRANSITION ANGLE BETWEEN STATIONS 727J AND 767 IAW SRM 53-00-53-2R.SDR AALA20161102012Intercostal · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. INTERCOSTAL AT RBL 31 IS CORRODED AT FUSELAGE STATION 991. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-00-05-1 AND DRAWING 147A5710.SDR AALA20151106002Battery Pack · dischargedLEFT & RIGHT AFT EMER LIGHTING BATTERY PACKS FAILED DURING MCM 2903 CARD. R & R LT & RT AFT EMER LIGHTING BATTERY PACKS IAW AMM 33-51-06, OPERATIONALLY CHECKED OK.SDR AALA20150111001Connector · disconnectedDURING SIC 2904 EMER LIGHT INSPECTION CHECK, DISCOVERED ROW 11 DEF & 21 DEF AISLE MARKER NOT ILLUMINATING. ROW 11 DEF & 21 DEF LOOSE CONNECTION, RECONNECTED. OPERATIONS CHECKED OK.SDR AALA20141229005Pump · failedINBOUND, RT ENGINE HYD PUMP FAILED THEN LOST HYD SYSTEM B. EMERGENCY DECLARED & LANDING UNEVENTFUL. REMOVED AND REPLACED THE NR 2 ENGINE HYDRAULIC PUMP IAW AMM 29-11-11. SYSTEM CHECKED NORMAL.SDR AALA20141106015Skin · corrodedFUSELAGE SKIN HAS AREA OF CORROSION BETWEEN STATIONS 1004 & 1007 FROM STRINGER 21 TO 22 LT. REMOVED CORROSION & REPAIRED IAW ENGINEERING AUTHORIZATION B737-53-037297 & SUPPLEMENT 037297 DATED 11/6/2014.SDR AALA20141106014Skin · corrodedFUSELAGE SKIN HAS SMALL AREAS OF CORROSION BETWEEN STATIONS 967 & 988 FROM STRINGERS 21 TO 22 LT. REMOVED CORROSION & REPAIRED IAW ENGINEERING AUTHORIZATION B737-53-037297 & SUPPLEMENT 037297 DATED 11/6/2014.SDR AALA20141106013Skin · corrodedFUSELAGE SIN HAS CORROSION AROUND LAVATORY VENT PORT AT STATION 917 BETWEEN STRINGERS 21 & 22 LT. REMOVED CORROSION & REPAIRED IAW ENGINEERING AUTHORIZATION B737-53-037298 DATED 6 NOV 2014.SDR AALA20141106012Skin · corrodedFUSELAGE SKIN HAS AREAS OF CORROSION BETWEEN STATIONS 1014 & 1017 FROM STRINGERS 19 TO 23 LT. REMOVED CORROSION & REPAIRED IAW ENGINEERING AUTHORIZATION B737-53-037297 & SUPPLEMENT 037297 DATED 11/6/2014.SDR AALA20121112017Skin · corrodedAFT LAVATORY VENT CORROSION FROM STATIONS 888 TO 907 AND STRINGERS 24 TO 25 LEFT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027040.SDR AALA20111004SFO01Lens · missingRED EMERGENCY LIGHT LENS AT SEAT 14D MISSING. REPLACED RED LENS FOR EMERGENCY LIGHT AT SEAT 14D. OPS CHECK NORMAL.
Back to N865NN