N396SW, cancelled Jul 9, 2022
Service difficulty reports · 397
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 = 'N396SW' AND deregistration_id = 'N396SW-2022-07-09' 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 = 'N396SW' AND deregistration_id = 'N396SW-2022-07-09' 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 SWAA2015022536875Fitting · corrodedLEFT NOSE GEAR LOWER LOCK ACTUATOR BRACKET CORRODED. REPAIRED FITTING IAW EA.SDR SWAA2015012235951Lens · missingLEFT EMER LIGHT LENS MISSING AT ROW 18. INSTALLED LENS IAW MM.SDR SWAA2015010535449Slide · looseR2 DOOR SLIDE LOOSE. R & R SLIDE ASSEMBLY IAW MM.SDR SWAA2014101032843Lens · looseEMERGENCY LIGHT LENS LOOSE ABOVE SEAT ROW 2 ABC. SECURED LENS IAW MM.SDR SWAA2014090931729Tee Fitting · corrodedRIGHT MLG WW HORIZONTAL TEE CORRODED AT BS 710. R & R TEE IAW EO & EA.SDR SWAA2014090931728Tee Fitting · corrodedRIGHT MLG WW VERTICAL TEE CORRODED AT BS 710. R & R TEE IAW EO & EA.SDR SWAA2014082831387Channel · crackedCHANNEL CRACKED AT BS 348.5 BETWEEN STRINGER 17L TO 16L. R & R CHANNEL IAW SRM.SDR SWAA2014090831635Stiffener · crackedLEFT WING NR 3 FLAP TRACK FAIRING STIFFENER CRACKED. R & R STIFFENER IAW SRM & DWG.SDR SWAA2014090231540Fitting · crackedRIGHT WING GND SPOILER OTBD FITTING CRACKED. R & R FITTING IAW SRM & DWG.SDR SWAA2014090331558Frame · crackedFRAME CRACKED AT BS 787 BETWEEN STRINGER 26R TO 25R. REPAIRED FRAME IAW SRM.SDR SWAA2014090231539Strap · crackedSTRAP CRACKED BETWEEN BS 348.2 TO 351.2 STRINGER 16L. R & R STRAP IAW SRM & DWG.SDR SWAA2014090231538Stringer Splice · crackedSTRINGER SPLICE CRACKED AT BS 907 STRINGER 3L. R & R SPLICE IAW SRM & DWG.SDR SWAA2014090231447Frame · crackedFRAME CRACKED AT BS 360 BETWEEN STRINGER 28L TO 28R. REPAIRED FRAME IAW EA.SDR SWAA2014082531169Tie Clip · crackedTIE CLIP CRACKED AT BS 360 STRINGER 10L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531168Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 9L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531167Tie Clip · crackedTIE CLIP CRACKED AT BS 360 STRINGER 8L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014082531166Tie Clip · crackedTIE CLIP CRACKED AT BS 360, STRINGER 5L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014090931727Stiffener · corrodedAFT PRESS BULKHEAD Z STIFFENER CORRODED AT BS 1016, BL 0. REPAIRED Z STIFFENER IAW EA.SDR SWAA2014090931726Bulkhead · corrodedAFT PRESS BULKHEAD WEB CORRODED AT BS 1016 RBL 5. REPAIRED WEB IAW EA NO.SDR SWAA2014090431588Angle · crackedCLIP ANGLE CRACKED AT BS 348.2 STRINGER 15L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014090431587Frame · crackedFRAME INNER CHORD CRACKED AT BS 348.2 STRINGER 17L. R & R CHORD IAW EA.SDR SWAA2014090331557Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 28L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014090231551Shear Tie · corrodedSHEAR TIE CORRODED AT BS 344 STRINGER 26R. R & R SHEAR TIE IAW SRM & DWG.SDR SWAA2014090231545Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360 STRINGER 28L. R & R SPLICE IAW SRM & DWG.SDR SWAA2014082831386Stringer Splice · crackedSTRINGER SPLICE CHANNEL CRACKED AT BS 360 STRINGER 7L. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014082731299Support Angle · crackedSUPPORT ANGLE CRACKED AT BS 294.5 STRINGER 23L. R & R SUPPORT IAW SRM & DWG.SDR SWAA2014082731298Angle · crackedANGLE CRACKED AT BS 328+9 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731297Angle · crackedANGLE CRACKED AT BS 328 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731296Angle · crackedANGLE CRACKED AT BS 312+9 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082731295Angle · crackedANGLE CRACKED AT BS 312 STRINGER 21L. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082631219Stringer Splice · corrodedSTRINGER SPLICE CORRODED AT BS 360 STRINGER 27L. R & R SPLICE IAW SRM & DWG.SDR SWAA2014082131066Angle · crackedANGLE CRACKED ON PLATE NR 2 TRANSMISSION. R & R ANGLE IAW SRM & DWG.SDR SWAA2014082131065Angle · crackedANGLE CRACKED ON PLATE NR 1 TRANSMISSION. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081931004Tie Clip · crackedTIE CLIP CRACKED AT BS 380 STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014090231550Keelbeam · crackedKEEL BEAM WEB CRACKED AT BS 710. R & R WEB IAW SRM & DWG.SDR SWAA2014082531165Fitting · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE FITTING CRACKED AT BS 303.9, STRINGER 13L. R & R FITTING IAW SRM & DWG.SDR SWAA2014090831634Tie Clip · crackedTIE CLIP CRACKED AT BS 947.5, STRINGER 25R. R & R TIE CLIP IAW EA.SDR SWAA2014090431586Frame · crackedSTUB FRAME CRACKED AT BS 951 BETWEEN STRINGER 16R TO 17R. REPAIRED STUB FRAME IAW EA.SDR SWAA2014082731294Angle · crackedANGLE CRACKED AT BS 500C STRINGER 26R. R & R ANGLE IAW SRM.SDR SWAA2014082631218Channel · crackedCHANNEL CRACKED AT BS 727 BL 0. R & R CHANNEL IAW SRM & DWG.SDR SWAA2014082531163Angle · crackedANGLE CRACKED BETWEEN BS 927 TO 947.5, BL 0. R & R ANGLE IAW SRM & DWG.SDR SWAA2014081931003Tie Clip · crackedTIE CLIP CRACKED AT BS 500A STRINGER 22R. R & R TIE CLIP IAW SRM.SDR SWAA2014081931002Tie Clip · crackedTIE CLIP CRACKED AT BS 500C STRINGER 27L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014081530904Tie Clip · crackedTIE CLIP CRACKED AT BS 727C STRINGER 20L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014081530898Tie Clip · crackedTIE CLIP CRACKED AT BS 727A, STRINGER 19L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014081530897Tie Clip · crackedTIE CLIP CRACKED AT BS 500B STRINGER 23L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014081530896Tie Clip · crackedTIE CLIP CRACKED AT BS 400, STRINGER 21L. R & R TIE CLIP IAW SRM & DWG.SDR SWAA2014091131829Skin · delaminatedRIGHT WING OTBD LOWER SURFACE INBD END OF OTBD AFT FLAP DELAMINATED. REPAIRED AFT FLAP IAW SRM.SDR SWAA2014090931725Skin · delaminatedRIGHT WING AILERON LOWER SURFACE DELAMINATED. R & R AILERON IAW AMM.SDR SWAA2014090331556Plate · crackedPLATE CRACKED AT BS 794 STRINGER 25R. R & R PLATE IAW SRM & DWG.
Back to N396SW, cancelled Jul 9, 2022