AD 72-03-03 R3
Registered aircraft · 17,028
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.
N8033GStoltz Curtis · Winter Haven, FLN8034FDavis Matthew B · Silsbee, TXN8035SLongstreth Seth Allen · Lancaster, OHN8036SStern Mark A · Tallevast, FLN8037GGuidry John M · Pensacola, FLN8037LSkyglide LLC · St George, UTN8038FJackovich Dennis A · Bettendorf, IAN8038SPainter Bryan · Renton, WAN8039GGreen Mortgage Corp · Walworth, WIN8040FWingfield Kyle M · Leesburg, GAN8040SNew Flight LLC · Dublin, VAN8042SBanning Braden L · Pleasant Hill, IAN8043GConnor Robert L · North Little Rock, ARN8043SLund William R · Escondido, CAN8044GTml Services LLC · The Villages, FLN8044LOverton Larry D · Hermiston, ORN8044ZLever Samuel C · Udall, KSN8045LAmonett Rodney · Abilene, TXN8046SHolmes Gerald P · Billerica, MAN8046ZBest Auto Sales LLC · Plummer, IDN8047FPoole Terrell W · Rigby, IDN8048FParris Morgan Aaron R · Taylors, SCN8048LFour Dudes And A Plane LLC · Whitehouse, OHN8048ZWalker John A · Kotzebue, AKN8049GStone & Phillips Aviation LLC · Youngstown, FLN8049LPrewitt Murray L · Lake Jackson, TXN8049STri State Aero Inc · Martinsburg, WVN804PMSmp Outdoors Inc · Joseph, ORN8050GJudge Simone · Greenwood, ARN8050LRobinette William B · Youngstown, OHN8050SWeeks George E · Trenton, SCN8051GMeyer Nicholas A · Indianapolis, INN8051QLucatorto Jeffrey A · Mc Gaheysville, VAN8051ZN8051z LLC · Anchorage, AKN8053FCurell Ken E · Centerville, OHN8053LSasser Jeremiah · Ceres, CAN8054GPelham Robert F · Glasgow, KYN8054LAdams Clint D · San Antonio, TXN8055FGerken James D Jr · Salem, VAN8055LRowden Paul G · Wichita, KSN8055SFoster Tommy L · Thaxton, VAN8056GYosten Patsy J · Greenville, TXN8056LJenkins Mark · Santa Clarita, CAN8057FThenappan Nachiappan · Round Rock, TXN8057LSale Reported · Kirksville, MOSale reportedN8060LOneonone Flight Training LLC · Hagerstown, MDN8060SGrinfeder Alex J · Little Rock, ARN8061Gibson Isaac S · Saint John, INN8061FMorales Jose · Mission, TXN8061GMolstad Jerome M · La Crosse, KS
Back to AD 72-03-03 R3