AD 72-03-03 R3
Registered aircraft · 17,027
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
ORDER BY n_number"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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') ORDER BY n_number
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.
N2272RBerntsen Kurt · Upland, CAN2272XSouthern Seaplane Inc · Belle Chasse, LAN2272YWilson Matthew C · Robinson, ILN22731Renehan Daniel G · Holly, MIN22738Barbaree Chan · Elba, ALN22741Wayne Brett M · Saint George, UTN2274JStone Kenneth R · Cedar Springs, MIN22758Clip Aire LLC · Mill Spring, MON22759Park Forest South Aviation Group · Mount Prospect, ILN22765Registration Pending · Buckeye, AZRegistration pendingN22771Whitney Walter F · Ham Lake, MNN22780Padgett Michael A · Ruffin, SCFirst renewal noticeN22784Mayeko-Coklee Thomas · Lake Worth, FLN22785Williams Jamar C · Louisville, KYN22788Jensen Rosemary · Quartz Hill, CAN22792Belmar Aviation Inc · Lexington, KYN2279JN2279j LLC · Burr Oak, MIN2279RLehmann Albert F II · Simpsonville, SCN227LLJ.R. Aero Ltd · Eldridge, IAN227SSRiver Front Akn LLC · Anchorage, AKN22802Ference Jeffrey J · Chandler, AZN2280RRusso John · Seaside, CAN22814Kruger Warren S · Kendall, NYN22821Stewart Dan R · Cashmere, WAN22826Cottrell Mark C · Leitchfield, KYN22828Shiroma Owen L · Stockton, CAN22829Vandervoort William L · Hector, MNN2282JReiner William · Anchorage, AKN22830Delancey Eddie J · Elizabeth, WVN22834Smith Earl K · Port Byron, NYN22836Smith David R · Lebanon, TNN22837Bielefeldt Brandon · Mondovi, WIN22839Morris Bernard J · Davenport, FLN2283JHill Douglas G · Winnebago, MNN22846White Daniel M · Agua Dulce, CAN22847Blue Skies Aviation LLC · Alexandria, VAN2284YBorn Daniel P · Lawrence, KSN2285YKrid Cardinal LLC · Centerville, INN22863Roberson Henry B · Chico, CAN22865Turner Tina L · Ford, WAN22867Jacobs Lydia A · North Pole, AKN22876Rhoads Eric Scott · Costa Mesa, CAN22879Jones Dennis P · Nacogdoches, TXN2287RTail Winds To The Island Inc · Ashland, KYN22882Vasiliou Adamos C · Burtonsville, MDN22886Sky High Adventures LLC · Wilmington, DEN22892Miller Frank L · Ninilchik, AKN22893Hoffer Patrick N · Orr, MNN22897Donn Rex · Washington, UTN22900Swanton Jed M · Shawnee, KS
Back to AD 72-03-03 R3