N1093A
Service difficulty reports · 308
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 = 'N1093A' 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 = 'N1093A' 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 UIEA2017032400392Stringer · crackedFWD CARGO BETWEEN BS 522 - 544, STRINGER 26L FOUND CRACKED. REMOVED AND REPLACED THE STRINGER SECTION AND REINFORCED AREA WITH HAT SECTION AND FILLER IAW SRM 53-00-03 FIG 201 REPAIR 2, AND INSTALLED IAW SRM 51-40-02..SDR UIEA2017032400393Stringer · crackedFWD CARGO BS 588, STRINGER 26L. STRINGER FOUND CRACKED. REMOVED DAMAGED STRINGER SECTION AND AREA REINFORCED WITH HAT SECTION AND FILLER.SDR UIEA2017030300278Stringer · crackedFWD CARGO B/T STA 478-500 STR 26L. STRINGER FOUND CRACKED. REMOVED DAMAGED STR SECTION AND REINFORCED AREA WITH HAT SECTION AND FILLER P/N N633GT. FABRICATED PER SRM 53-00-03 FIG 201 REPAIR-2 INSTALLED PER SRM 51-40-02.SDR UIEA2017030300281Stringer · crackedFWD CARGO B/T STA 522-544 STR 26L STRINGER FOUND CRACKED. REMOVED DAMAGED STR SECTION AND REINFORCED AREA WITH HAT SECTION AND PILLER P/N: N633GT. FABRICATED PER SRM 53-00-03 FIG 201 REPAIR-2 INSTALLED PER SRM 51-40-02.SDR UIEA2017030300283Stringer · crackedFWD CARGO BS 588, STRINGER 26L FOUND CRACKED. REMOVED DAMAGED STRINGER SECTION AND A REPAIR WAS FABRICATED IAW SRM 53-00-03, FIG 201, REPAIR 2.SDR UIEA2017030300291Stringer · crackedMAIN DECK BS 368, STRINGER 10L FOUND CRACKED. TRIMMED DAMAGE STRINGER SEGMENT IAW SRM 51-10-02. A REPAIR WAS FABRICATED IAW SRM 53-00-03, FIG 201, REPAIR 1.SDR UIEA2017030300293Stringer · crackedFWD CARGO BAY, BS 478 - 500, STRINGER 26L FOUND CRACKED. REMOVED THE DAMAGED STRINGER SECTION AND FABRICATED A REPAIR IAW SRM 53-00-03, FIG 201, REPAIR 2. INSTALLED IAW SRM 51-40-02.SDR UIEA2017030300294Stringer · crackedFWD CARGO BAY, BS 522 - 544, STRINGER 26L FOUND CRACKED. REMOVED THE STRINGER SECTION AND FABRICATED A REPAIR IAW SRM 53-00-03, FIG 201, REPAIR 2, AND INSTALLED IAW SRM 51-40-02.
Back to N1093A