N306NY
Service difficulty reports · 67
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 = 'N306NY' 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 = 'N306NY' 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 AALA202212019407Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO CLOSE AND SECURE. ADJUSTED COCKPIT DOOR LOCK.SDR AALA202205244553Lens · missingAIRCRAFT WAS NOT GROUNDED: LENS COVER FOR AFT LEFT EMERGENCY EXIT LIGHT MISSING. REPLACED LENS PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA202202141479Lens · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT COVER MISSING AT AFT LH SERVICE DOOR. REPLACED LENS WITH NEW, OPS CHECK GOOD.SDR AALA202202029223Bracket · out of adjustAIRCRAFT WAS NOT GROUNDED: CABIN DOOR 1R GIRT BAR HOLDER DOES NOT HOLD BAR UP OFF OF FLOOR. ADJUSTED R1 DOOR GIRT BAR HOLDER BRACKETS AS REQUIRED PER AMM 25-66-01.SDR AALA202201215115Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLOOR/ SEAT LIGHT AT SEAT 21C IS HANGING FROM SEAT. REINSTALLED SEAT MOUNTED EMERGENCY LIGHT AT SEAT 21C. CHECKED OK PER AMM 33-51-11.SDR AALA202112074408Floorboard · noneAIRCRAFT WAS GROUNDED: SOFT FLOORBOARD IN AISLE AT SEAT ROW 19. REPLACED FLOORBOARD WITH NEW IAW AMM 25-22-00, OPS CHECK GOOD.SDR AALA202104089017Slide · out of positionAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE FELL OUT OF CASING. RE-SECURED L1 DOOR SLIDE IN ITS COMPARTMENT PER AMM 25-66-01.SDR AALA202012149024Bracket · out of positionAIRCRAFT WAS NOT GROUNDED. RT FWD GALLEY SERVICE DOOR SLIDE BRACKET DOES NOT HOLD SLIDE DISARMED. ADJUSTED SLIDE BRACKET, IAW AMM 25-66-01. OPERATIONS CHECK GOOD.SDR AALA202012149023Screw · missingAIRCRAFT WAS NOT GROUNDED. RT AFT SERVICE DOOR SLIDE BRACKET MISSING SCREWS. REPLACED MISSING SCREWS, IAW AMM 25-66-01. OPERATIONS CHECK GOOD.SDR AALA2020070439005Flashlight · dislodgedAIRCRAFT NOT GROUNDED - L4 EMERGENCY FLASHLIGHT, LED DOES NOT FLASH. RESEATED FLASHLIGHT AND INSTALLED NEW TAMPER SHIELD, PER AMM 25-64-00, OPERATIONAL CHECK NORMAL.SDR AALA2020070439004Flashlight · dislodgedAIRCRAFT NOT GROUNDED - L1 EMERGENCY FLASHLIGHT, LED DOES NOT FLASH. RESEATED FLASHLIGHT AND INSTALLED NEW TAMPER SHIELD, PER AMM 25-64-00, OPERATIONAL CHECK NORMAL.SDR AALA201907299002Cover · unsecureAIRCRAFT WAS NOT GROUNDED: MID CABIN EXIT SIGN COVER FELL OFF. MAINTENANCE REINSTALLED SIGN PER AMM 33-51-01.SDR AALA201811149022Megaphone · inoperativeTUL - THE AIRCRAFT WAS NOT GROUNDED. MEGAPHONE IN F/C DOESN’T WORK. MAINTENANCE REMOVED AND REPLACED F/C MEGAPHONE IAW AMM 25-64-00.SDR AALA201807239020Idg · inoperativeAIRCRAFT WAS GROUNDED. DFW-BZN DIVERTED DEN ACCOUNT DUAL GENERATOR FAILURE AND ON APU POWER. AN EMERGENCY WAS DECLARED. FLIGHT LANDED WITHOUT INCIDENT. BOTH BUS TRANSFER/SOURCE LIGHTS ILLUMINATED. LOST MOST SYSTEMS INCLUDING PRESSURIZATION. STARTED APU, RESTORSDR AALA20180720002Bpcu · failedAIRCRAFT WAS GROUNDED. DFW-BZN DIVERTED DEN ACCOUNT DUAL GENERATOR FAILURE AND ON APU POWER. AN EMERGENCY WAS DECLARED. FLIGHT LANDED WITHOUT INCIDENT. BOTH BUS TRANSFER/SOURCE LIGHTS ILLUMINATED. LOST MOST SYSTEMS INCLUDING PRESSURIZATION. STARTED APU, RESTORSDR AALA201708249014Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE LOWER R1 DOOR HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161229016Indicator · faultyAIRCRAFT NOT GROUNDED. EMERGENCY DECLARED. BOS-ORD FLIGHT RETURNED TO BOS ACCOUNT LEADING EDGE FLAP TRANSMITTER INDICATION. FLAPS STUCK AT 1/2 DEGREE, HANDLE 0. OVERWEIGHT LANDING UNEVENTFUL. REMOVED AND REPLACED FLAP POSITION INDICATOR IAW AMM 27-58-02-000-80
Back to N306NY