Boeing 737-7L9
Service difficulty reports · 1,024
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '7377L9' 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 aircraft_model_key = '7377L9' 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 2009FA0000566Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET AT BS 480 STRINGER 9 RIGHT.SDR 2009FA0000565Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET AT BS 440, STRINGER 9 RT.SDR 2009FA0000562Cargo Track · corrodedOUT OF LIMITS CORROSION ON THE TOP SURFACE OF THE AFT PIT RAIL ASSY AT BS 791.5 RBL 8.1.SDR 2009FA0000561Cargo Track · corrodedOUT OF LIMITS CORROSION ON THE TOP SURFACE OF THE AFT PIT RAIL ASSY AT BS 791.5 LBL 8.1.SDR 2009FA0000560Cargo Track · corrodedOUT OF LIMITS CORROSION ON TOP SURFACE OF THE AFT PIT RAIL ASSY AT BS 791.5 LBL 3.0.SDR 2009FA0000559Cargo Track · corrodedOUT OF LIMITS CORROSION ON TOP SURFACE OF THE AFT PIT RAIL ASSY AT BS 791.5 RBL 3.0SDR 2009FA0000551Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 827 STRINGER 9 LT.SDR 2009FA0000550Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 827 STRINGER 9 RT.SDR 2009FA0000547Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 500C STRINGER 9 RT.SDR 2009FA0000543Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET, BS787, STRINGER 9L.SDR 2009FA0000542Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 727D, STRINGER 9L.SDR 2009FA0000541Frame · crackedFRAME CRACKED AT A/C ATTACH BRACKET, BS 747, STRINGER 9R.SDR 2009FA0000540Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 727D STRINGER 9R.SDR 2009FA0000539Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 727B STRINGER 9R.SDR 2009FA0000538Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 360 STRINGER 9R.SDR 2009FA0000537Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 500A, STRINGER 9R.SDR 2009FA0000536Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 400 STRINGER 9LSDR 2009FA0000535Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET, BS 867, STRINGER 9R.SDR 2009FA0000534Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 360 STRINGER 9L.SDR 2009FA0000533Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 747 ABOVE STRINGER 9L.SDR 2009FA0000532Frame · crackedFUSELAGE FRAME CRACKED AT A/C ATTACH BRACKET BS 400 ABOVE STRINGER 9R.SDR 2009FA0000531Floorbeam · corrodedOUT OF LIMITS CORROSION ON CABIN FLOORBEAM BS 947.5 WL208.1 LBL 10- RBL 10.SDR 2009FA0000530Floorbeam · corrodedOUT OF LIMITS CORROSION ON FLOOR SUPPORT AT BS 955 WL 207 RBL 29-36.SDR 2009FA0000529Intercostal · corrodedOUT OF LIMITS CORROSION ON FLOOR SUPPORT AT R2 DOOR THRESHOLD BS 960 WL207 RBL 52.
Back to Boeing 737-7L9