N7723E
Service difficulty reports · 270
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 = 'N7723E' 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 = 'N7723E' 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 SWAA2017042513286Gusset · crackedFORWARD GUSSET CRACKED AT BS 500D, STRINGER 19R. R & R GUSSET IAW SRM & DWG.SDR SWAA2017042513285Gusset · crackedFORWARD GUSSET CRACKED AT BS 500D, STRINGER 19L. R & R THE GUSSET IAW SRM.SDR SWAA2017042113284Floor Support · crackedFLOOR SUPPORT CRACKED AT BS 344 TO 360, LBL 11, WL 207. R & R THE FLOOR SUPPORT IAW SRM.SDR SWAA2017042113283Floor Support · crackedFLOOR SUPPORT CRACKED AT BS 344 TO 360, BL 0, WL 207. R & R THE FLOOR SUPPORT IAW SRM.SDR SWAA2017041013036Floor Support · crackedFLOOR SUPPORT CRACKED BETWEEN BS 312 TO 328, LBL 46. R & R THE FLOOR SUPPORT IAW SRM.SDR SWAA2017042513308Web · corrodedAFT CARGO BAY SUB THRESHOLD WEB CORRODED. R & R THE WEB IAW SRM & DWG.SDR SWAA2017031712555Lens · missingLEFT EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED THE LENS IAW MM.SDR SWAA2017022812198Bracket · looseR1 DOOR SLIDE GIRT BAR LOOSE. SECURED THE GIRT BAR HOLDING BRACKET IAW SIP.SDR SWAA2016091907953Light · inoperativeL2 DOOR OVERHEAD EMERGENCY EXIT SIGN BULB INOPERATIVE. R & R BULB IAW AMM.SDR SWAA2016010447630Sign · looseAFT CABIN OVERHEAD EMER EXIT SIGN LOOSE. R & R SIGN IAW MM.SDR SWAA2015102745424Floor Support · crackedFLOORBOARD SUPPORT CRACKED AT BS 540, BL 0. R & R SUPPORT IAW SRM.SDR SWAA2015102245252Pressure Panel · crackedMAIN WW VERTICAL PRESS WEB CRACKED AT BS 663, BETWEEN RBL 34 - RBL 35. REPAIRED WEB IAW SRM.SDR SWAA2015102245251Pressure Panel · crackedMAIN WW VERTICAL PRESS WEB CRACKED AT BS 663, BETWEEN RBL 42 - RBL 43. REPAIRED WEB IAW SRM.SDR SWAA2015100744650Light · inoperativeLEFT AFT OF WING TO BODY EMER LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2015050439273Slide · out of positionL2 DOOR EMER DOOR SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW SIP.SDR SWAA2015010235400Stiffener · crackedLEFT HORIZONTAL STAB RIB STIFFENER CRACKED AT STATION 101.39. REPAIRED STIFFENER IAW SRM.SDR SWAA2015010235404Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 727B, RBL 45. REPAIRED IAW EA.SDR SWAA2015010235403Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 727B, RBL 45. REPAIRED IAW EA.SDR SWAA2015010235402Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 727B, LBL 25. REPAIRED IAW EA.SDR SWAA2015010235401Floor Support · crackedLONGITUDINAL FLOORBEAM CRACKED AT STATION 727B, LBL 45. REPAIRED IAW EA.
Back to N7723E