Embraer SB 505-55-0004
Service difficulty reports that cite it · 42
Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.
Query with SQL
duckdb -csv -c "SELECT s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id
WHERE c.document_id = 'embraer/sb-505-55-0004' AND c.record_type = 'faa_service_difficulty_report'
GROUP BY ALL
ORDER BY max(c.record_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 s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions, bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id WHERE c.document_id = 'embraer/sb-505-55-0004' AND c.record_type = 'faa_service_difficulty_report' GROUP BY ALL ORDER BY max(c.record_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 2022F00132None · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01, ONE AILERON MASS BALANCE WEIGHT WAS FOUND TO BE BELOW MINIMUM WEIGHT. REPLACED WEIGHT WITH NEW, PART NUMBER PE915109-L31 PER SERVISDR 2021FA0000087Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2021FA0000076Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHT BELOW TOLERANCE AT LEFT ELEVATOR: HORN MASS WEIGHT PART NUMBER PE9151SDR 2021FA0000065Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT AILERON: AILERON MASS WEIGHT PART NUMBER PE9SDR 2021FA0000064Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHT BELOW TOLERANCE AT LEFT ELEVATOR: HORN MASS WEIGHT PART NUMBER PE9151SDR 2021F00025Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBERPE91SDR 2021FA0000028Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHT BELOW TOLERANCE AT LEFT ELEVATOR: HORN MASS WEIGHT PART NUMBER PE9151SDR 2021FA0000019Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT RIGHT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PESDR 2021FA0000014Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE: RUDDER ADJUSTABLE WEIGHTS PART NUMBER PE915109-L27 SDR 2021FA0000017Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2021FA0000018Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2021FA0000015Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2021FA0000000Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2020FA0000535Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR JGVR20201210001Balance Weight · Emb EMB505WHILE COMPLYING WITH EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHTS DO NOT MEET SB SPECIFICATIONS AND REQUIRING REPLACEMENT. ONE RT ELEVATOR HORN WEIGHT P/N PE915109-L42, FISDR 2020FA0000523Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2020FA0000512Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2020FA0000511Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR JGVR202011180001Balance Weight · Emb EMB505WHILE COMPLYING WITH EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHT TO NOT MEET SB SPECIFICATIONS AND REQUIRING REPLACEMENT: ONE LT ELEVATOR HORN WEIGHT P/N PE915109-L42, TWESDR JGVR20201116001Balance Weight · Emb EMB505DURING APPLICATION OF EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHTS NOT ACCEPTABLE AND REQUIRING REPLACEMENT. INSTALLED 3 LT ELEVATOR ADJUSTABLE BALANCE WEIGHTS P/N: PE9151SDR 2020FA0000504Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2020FA0000503Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR. ADJUSTABLE WEIGHTS PART NUMBER PE9SDR JGVR202011111001Counterbalance · Emb EMB505WHILE COMPLYING WITH EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHTS NOT ACCEPTABLE AND REQUIRING REPLACEMENT: RT ELEVATOR (10 ADJUSTABLE BALANCE WEIGHTS P/N PE915109-L33), RSDR 2020FA0000496Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2020FA0000486Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR JGVR2020029002Balance Weight · Emb EMB505WHILE COMPLYING WITH EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHTS NOT ACCEPTABLE AND REQUIRING REPLACEMENT. ONE LT ELEVATOR HORN WEIGHT P/N PE915109-L42, 10 LT ELEVATOR ADSDR JGVR20201029002Balance Weight · Emb EMB505WHILE COMPLYING WITH EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHTS NOT ACCEPTABLE AND REQUIRING REPLACEMENT. ONE LT ELEVATOR HORN WEIGHT P/N PE915109-L42, 10 LT ELEVATOR ADSDR 2020FA0000456Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR. ADJUSTABLE WEIGHTS PART NUMBER PE915109-L33 (4 ESDR 2020FA0000454Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 PART I,II,III (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE: LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE915SDR JGVR20201016001Balance Weight · Emb EMB505WHILE COMPLYING WITH EMBAER SB 505-55-0004 FOUND THE FOLLOWING, FLIGHT CONTROL BALANCE WEIGHTS NOT ACCEPTABLE AND REQUIRING REPLACEMENT. THREE RT ELEVATOR ADJUSTABLE BALANCE WEIGHTS P/N PE915109-L33 ASDR JGVR20201012001Balance Weight · Emb EMB505WHILE COMPLYING WITH EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHTS NOT ACCEPTABLE AND REQUIRING REPLACEMENT: LH ELEVATOR HORN WEIGHT P/N PE915109-L42; TWO RT ELEVATOR ADJUSSDR 2020FA0000443Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 PART I, II, III (DATED 06/24/2020), WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR. ADJUSTABLE WEIGHTS PART NUMBER SDR 2020FA0000439Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 (DATED 06/24/2020), WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE915109-L33 (4 SDR JGVR20201005001Balance Weight · Emb EMB505WHILE COMPLYING WITH EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHTS NOT ACCEPTABLE AND REQUIRING REPLACEMENT. LT ELEVATOR HORN WEIGHT P/N PE915109-L42, RT ELEVATOR HORN WEIGSDR 2020FA0000435Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 (DATED 06/24/2020), WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE915109-L33 (16SDR 2020FA0000429Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 (DATED 06/24/2020), WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE915109-L33 (9 SDR 2020FA0000426Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 (DATED 06/24/2020), WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE915109-L33 (3 EASDR 2020FA0000420Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 (DATED 06/24/2020), WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE915109-L33 (3 EASDR 2020FA0000421Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 (DATED 06/24/2020), WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE915109-L33 (10 ESDR JGVR20200921001Balance Weight · Emb EMB505WHILE COMPLYING WITH EMBRAER SB 505-55-0004 FOUND THE FOLLOWING FLIGHT CONTROL BALANCE WEIGHTS NOT ACCEPTABLE PER SB AND REPLACED WITH NEW PARTS. ONE LT ELEVATOR HORN WEIGHT P/N PE915109-L42, ONE LT ESDR 2020FA0000418Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SERVICE BULLETIN 505-55-0004 REV 01 (DATED 06/24/2020) WE NOTED THE FOLLOWING MASS BALANCE WEIGHTS BELOW TOLERANCE AT LEFT ELEVATOR: ADJUSTABLE WEIGHTS PART NUMBER PE9SDR 2020FA0000376Balance Weight · Emb EMB505DURING ACCOMPLISHMENT OF EMBRAER SB 505-55-0004 REV 01 (DATED 06/24/2020), WE NOTED THE FOLLOWING LEFT ELEVATOR MASS BALANCE WEIGHT BELOW TOLERANCE: P/N PE915109-L33 (1 EACH) UNDER THE WEIGHT LIMITS (
Back to Embraer SB 505-55-0004