N881NN
Service difficulty reports · 61
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 = 'N881NN' 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 = 'N881NN' 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 AALA201712059059Handle · out of adjustAIRCRAFT WAS GROUNDED. FIRST OFFICER'S EXTERNAL SLIDING WINDOW EMERGENCY EXIT HANDLE IS OUT OF ADJUST, HAS EXCESSIVE PLAY. ADJUSTED HANDLE TO FLUSH EXTERIOR PER AMM 56-12-11-820-801. OPERATIONAL CHECK GOOD.SDR AALA20170929008Transition Panel · corrodedCORROSION ON FORWARD CARGO LEFT TRANSITION PANEL BETWEEN BS 500 AND 500G. REPAIRED THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA20170928013Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BETWEEN BS 312 - 328, LBL46. REMOVED AND REPLACED THE FLOOR SUPPORT 51-00-05-01 AND DRAWING 141A5400.SDR AALA20170927004Rail · corrodedCORROSION ON FORWARD CARGO AFT LOWER BULKHEAD RAIL AROUND THE FASTENER HOLES AT BS 500I, BETWEEN STRINGERS 28L AND 28R. REMOVED AND REPLACED RAIL ASSEMBLY IAW 51-00-05-1 AND SRM 51-10-02.SDR AALA20170926007Support Angle · corrodedCORROSION ON FORWARD SERVICE DOOR CREASE ANGLE ON THE VERTICAL FLANGE AT RBL 58 BETWEEN BS 308 - 328. REMOVED AND REPLACED SUPPORT ANGLE IAW 51-00-05 AND DRAWING 141A312.SDR AALA20170926003Floor Support · crackedCRACKED CABIN FLOOR SUPPORT BS 344 - 360, LBL 12. REMOVED AND REPLACED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 141A5400.SDR AALA20170929005Floorbeam · crackedCRACKED FLOORBEAM ANGLE AT BS 540, LBL 2. REMOVED AND REPLACED THE ANGLE IAW SRM 51-10-02-0G, PARAGRAPH 9.SDR AALA201708289010Lens · brokenEMERGENCY EXIT LIGHT AT THE L2 DOOR HAS A BROKEN LENS COVER. REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECKED GOOD.SDR AALA201708219055Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 23ABC HAS A MISSING LENS COVER. INSTALLED LENS COVER PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA201705169033Lens · missingEMERGENCY EXIT LIGHT ABOVE SEAT 10D HAS A MISSING LENS. REPLACED THE LENS IAW AMM 33-20-00. OPS CHECKED GOOD.SDR AALA20170203013Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L2 DOOR HAS A MISSING LENS COVER. RESECURED LENS COVER. OPERATIONAL CHECK GOOD.
Back to N881NN