N721AN
Service difficulty reports · 111
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 = 'N721AN' 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 = 'N721AN' 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 AALA201709089027Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT OUTSIDE OF LAVATORY 3F-RC HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-05. OPERATIONAL CHECK GOOD.SDR AALA201707149021Light · false activationEXIT EMERGENCY LIGHT ON SWITCH PANEL STARTED RINGING. MAINTENANCE ACCOMPLISHED LAVATORY SMOKE DETECTION TEST IAW MM 26-13-00. LIGHT EXTINGUISHED, NO FAULT NOTED. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECKED.SDR AALA20161207012Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY ESCAPE PATH FLOOR PROXIMITY LIGHT AT SEAT 9G IS MISSING LENS. REPLACED LENS IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20160921009Coffeemaker · odorFORWARD GALLEY ESPRESSO MAKER GIVES OFF A PLASTIC ODOR WHEN USED. MAINTENANCE REMOVE AND REPLACED ESPRESSO MACHINE IAW AMM 25-32-01.SDR AALA20160407005Slide Raft · unlacedAIRCRAFT WAS IN BASE MX. R5 DOOR SLIDE & RAFT IS UNLACED AT BOTTOM OF SLIDE & RAFT PACK. R & R SLIDE & RAFT.SDR AALA20160405020Power Supply · faultyAIRCRAFT WAS IN BASE MX. SEVERAL EMER LIGHTS IN OVERHEAD FLIGHT ATTENDANT REST FAILED BATTERY PACK CAPACITY TEST. R & R POWER SUPPLY M33142 & ACCOMPLISHED INSTALLATION CHECK IAW MM 33-51-06-960-803. SYS CHECKED NORMAL.SDR AALA20160407013Connector · looseAIRCRAFT WAS IN BASE MX. FIRST CLASS EMER LIGHTING INOPERATIVE. FOUND CONNECTOR LOOSE AT SEAT 1D, RESEATED CONNECTOR IAW AMM 33-57-00-710-802.SDR AALA20160407012Slide · unlacedAIRCRAFT WAS IN BASE MX. L5 DOOR SLIDE & CRAFT IS UNLACED AT BOTTOM OF SLIDE & RAFT PACK. R & R SLIDE & RAFT IAW 25-66-01-400-801.SDR AALA20160212006Coffeemaker · overheatedELECTRICAL ODOR IN FIRST CLASS GALLEY. CAPPUCCINO MAKER APPEARS OVERHEATED. DEACTIVATED THE CAPPUCCINO MAKER & FIRST CLASS EMER POWER. NO EMER WAS DECLARED & FLIGHT CONTINUED. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. REMOVED CAPPUCCINO MAKER & NOTICED SDR AALA20141112001Lens · missingEMERGENCY EXIT LIGHT COVER AT FDCR DOOR IS OFF, NEEDS REPLACEMENT. REPLACED EMER LIGHT LENS AT FDCR STAIR BULKHEAD IAW AMM 33-51-05. SYS CHECKED NORMAL.SDR AALA20140301003Smoke Detector · false activationNUISANCE SMOKE ALARM AT LAVATORY 4L UPON TRANSFER TO GROUND POWER. RESET LAVATORY 4L SMOKE DETECTOR. ACCOMPLISHED LAVATORY SMOKE DETECTOR TEST IAW AMM 26-13-00, TEST PASSED, OPERATIONS CHECKED NORMAL.
Back to N721AN