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.
N7101GBowhawk LLC · Ocala, FLN7101SCuellar Lauren · Eagle River, AKN71028Hawkins Joann L · Cupertino, CAN7102GBarbosa Manuel · Apple Valley, MNN7102QJuckett Jimmy L · Springhill, LAN71033Guthmiller David L · Lake Havasu City, AZN7103GMountain Flyers Inc · Hendersonville, NCN7103SHammerstrand John L · Alpine, CAN71040Benegar Al · Visalia, CAN71041Velez-Colon Luis X · Cibolo, TXN71045Bandstra Larry J · Heath Springs, SCN71047Lakehouse Aviation LLC · Peoria, ILN7104GAir Carriage LLC · Chico, CAN7104SHelm Richard A · Buckeye, AZN71050Shutt Noel M · Atascadero, CAN71065Setty Matthew M · Reno, NVN71069Johnson Wayne L · Spokane, WAN71070Taylor Mark R · Washington, UTN71074Bas Part Sales LLC · Greeley, CON71076Vrem Kelly L · Washington, UTN71077Duch Jose M · Miami, FLN7107FPoe John B Jr · Port Orange, FLN7107GSkyward Aviation LLC · Westborough, MAN71084Mccarty Kennith E · Eagle River, AKN7108GLakes Area Aviation LLC · Little Falls, MNN7108QAnderson Michael · Hillsboro, NDN7108SChapman Gary M · Sagle, IDN71099Michie Robert B · Austin, TXN7109QLawless Bruce A · Lago Vista, TXN710FGKimbrell Jeffrey L · Greenville, SCN71107Jrf Enterprises LLC · Salem, ORN7110QLawson Virgil · Sylvar Grove, KSN71114Aeropaws Aviation LLC · Front Royal, VAN71118Taf Aerial Services LLC · Beeville, TXN71121Karmy Jeffrey R · Medford, ORN71123Debusk Eric M · Columbus, INN71124N71124 LLC · Waunakee, WIN71126Overturf Andrew · Franklin, WIN7112FHurst Richard H · Lometa, TXN7112GHooper Walter E III · Spring City, TNN7112SBridges Robert S · Friendswood, TXN71132Neale Bruce G · Joppa, ALN711333 F Aviation LLC · Norwood, LAN71136Jones Harper L II · Pendleton, ORN7113QMiles Michael G · Hillsborough, NCN71149Skydive Harbor Springs Inc · Charlevoix, MIN7114FWernecke Thomas C · Southfield, MIN7114QSass Kenneth · Charlotte, NCN7115QMaggart Kenneth R · Lutz, FLN71164Core Jerry M · Bishop, CA
Back to AD 72-03-03 R3