N452PA
Service difficulty reports · 208
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 = 'N452PA' 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 = 'N452PA' 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 P5CA0301005Solenoid · failedNR 3 ENG FAILED TO START. REMOVED AND REPLACED NR 3 HMM SOLENOID SHUT OFF VLV IAW 73-21-20. ENG RUN-UP AND LEAK CK OK.SDR P5CA0200647Caster · crackedRT MAIN DECK BS 1725 CASTER TRAY EXTRUSION CRACKED/DAMAGED. REPAIRED PER SRM 51-70-11 FIG 1 & PER MM 25-57-04.SDR P5CA0200646Fairing · delaminatedNR 7 CANOE ASSY, OUTBOARD SIDE AT MID POINT 2 INCH DELAMINATION. REPAIRED PER SRM 51-40-00.SDR P5CA0200645Floorboard · puncturedMAIN DECK L/S FLOOR BOARD PUNCTURE BS 1720 LT SIDE. REPAIRED PER SRM 53-00-50.SDR P5CA0200644Caster · crackedMAIN DECK CASTER ASSY AT BS 1900 R/S CRACKED. REPAIRED PER SRM 51-40-00.SDR P5CA0200643Lock · damagedFWD CARGO COMPT AT STA 650 LOCK ASSY DAMAGED LEFT SIDE. REMOVED AND REPLACED PER MM 25-56-33.SDR P5CA0200642Guide · damagedAFT CARGO COMPT, STA 1820 SIDE GUIDE RAIL DAMAGED LT/SIDE. REPAIRED PER SRM 51-70-12 & MM 25-33-00.SDR P5CA0200641Floor Panel · puncturedMAIN DECK, STA 1920/2040 LEFT SIDE FLOOR PANEL DAMAGED (PUNCTURES). REMOVED AND REPLACED PER MM 53-00-50.
Back to N452PA