N7721E
Service difficulty reports · 268
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 = 'N7721E' 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 = 'N7721E' 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 SWAA2015051139539Slide · out of positionR1 DOOR EMER EVAC SLIDE GIRT BAR OUT OF POSITION. REPOSITIONED SLIDE IAW MT.SDR SWAA2015050839457Slide · out of positionR1 DOOR EMER EVAC SLIDE OUT OF POSITION. REPOSITIONED SLIDE IAW MM.SDR SWAA2015021636631Slide · looseL1 DOOR EVAC SLIDE LOOSE. SECURED SLIDE IAW MM.SDR SWAA2015012135926Battery · failedAFT RT EMER LIGHT BATTERY FAILED TIME TEST. R & R BATTERY IAW MM.SDR SWAA2014041627163Slide · looseL1 DOOR EMERGENCY EVAC SLIDE LOOSE. SECURED SLIDE IAW MT.SDR SWAA2014033126665Light · inoperativeRIGHT EMERGENCY EXIT LIGHT INOPERATIVE BETWEEN ROW 11 TO ROW 14. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2014022025331Girt Bar · out of positionL1 DOOR EMERGENCY EVAC SLIDE GIRT BAR OUT OF POSITION. REPOSITIONED GIRT BAR IAW MM.SDR SWAA2014021825283Light · inoperativeLT AFT LOWER BODY EMERGENCY EXIT LIGHT BEHIND LT FLAP INOPERATIVE. R & R LIGHT IAW MM.SDR SWAA2014021825282Light · inoperativeL2 DOOR EXTERNAL EMERGENCY EXIT LIGHT INOPERATIVE. R & R LIGHT IAW MM.SDR SWAA2014021725251Lens · crackedAFT ENTRY WAY CTR CEILING PANEL EMERGENCY EXIT LIGHT LENS CRACKED. R & R LENS IAW MM.SDR SWAA2014021825281Light · inoperativeEMERGENCY EXIT LIGHT ON AFT FACE OF G 1 GALLEY BULB INOPERATIVE. R & R BULB IAW MM.SDR SWAA2014021825280Connector · looseRT OVERWING EMERGENCY EXIT LIGHT SIGN LOOSE. SECURED CONNECTOR IAW MM.SDR SWAA2014021825279Light · inoperativeFWD LAVATORY AFT WALL EMERGENCY LIGHT LAMPS INOPERATIVE. R & R LAMPS IAW MM.SDR SWAA2014021725250Skin · crackedLT WING NR 1 SLAT NOSE SKIN AT ACTUATOR RIBS FWD OTBD FASTENER CRACKED. REPAIRED SKIN IAW ER.SDR SWAA2014021725184Beam · crackedBEAM CRACKED AT BS 727B, RBL 24.75. REPAIRED BEAM IAW EA.SDR SWAA2014021725183Beam · crackedBEAM CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM IAW EA.SDR SWAA2014021725182Beam · crackedBEAM CRACKED AT BS 727B, LBL 45.5. REPAIRED BEAM IAW EA.SDR SWAA2014021725181Beam · crackedBEAM CRACKED AT BS 727B, LBL 24.75. REPAIRED BEAM IAW EA.
Back to N7721E