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.
N7060SDygas Pauel · Pomerene, AZN70616Washburn Darlene J · Newberg, ORN70617Mcnutt John W · Seattle, WAN70618Allen Steven P · Flagstaff, AZN7061QMccutcheon Henry C · Frankfort, KYN7061SDirar Farras S E · Sackets Harbor, NYN7062Carvagno Lawrence · Trinity, ALN70625Resong Joseph J · Garden Grove, CAN7062GNorthwoods Aviation LLC · Eagle River, WIN7062SPrecision Aerospace Corp · Sarasota, FLN70632Galion Air Inc · Galion, OHN70633North County Flying Club · Tehachapi, CAFirst renewal noticeN70634Sowry Myron E · Phillipsburg, OHN70635Sitatunga Springs LLC · River Hills, WIN7063GL A H Eickhoff Farms Inc · Falls City, NEN7063QCarver Clarence K · Lutz, FLN70649Carroll Aviation Inc · Carroll, IAN7064SCuddington Mark E · Puyallup, WAN70651Sale Reported · Lakewood, COSale reportedN70655Kusterer James E Jr · Nampa, IDN70657Cobra Kai Inc · Wichita Falls, TXN70658Vroom David H · Oro Valley, AZN7065GAden David L · Keenesburg, CON7065JAmendt Inc · Sedgwick, CON7066FLamb Barry J · Moran, KSN7066GSwindle Don K · Collinsville, TXN7067GAngelle Kelli R · New Roads, LAN70686Haase Douglas R · Manassas, VAN70688Roesner David A · Salina, KSN7068FAndrew David N · Manhattan, ILN7068QWestwind Aviation Inc · Bremerton, WAN70695Tucker Whitney L · Gove, KSN70697Whalen Charles R · Gladewater, TXN70698Martin Kenneth R · Mill Creek, WAN7069GAjf Enterprises LLC · Des Moines, IAN7069QFlakker Michael E · Gold Hill, NCN706PREvoaviation LLC · Watkinsville, GAN7070FDaub David M · Sealy, TXN7070GGade Christopher P · Williston, VTFirst renewal noticeN70710Embyr November LLC · Gunnison, CON7071GWings Over Texas Holdings LLC · Denton, TXN7071QSun Country Aero Club · The Villages, FLN7072FMiller Richard M · New Galilee, PAN7072GMears Benjamin W III · Eastville, VAN7072QB&R Aircraft LLC · Wadsworth, OHN7072SEstby Hans P · Hayfield, MNN7073FBushby David R · Barnesville, GAN7073GSky Warriors LLC · Hayward, CAN70740Sierra Bravo Air LLC · Winston Salem, NCN7074SBoening Bros Dust & Spray Svc · Floresville, TX
Back to AD 72-03-03 R3