AD 2003-24-13
Registered aircraft · 7,870
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:2003-24-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13')
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:2003-24-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-24-13') 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.
N723SEFrost Cavin Bert · Odessa, TXN723SPElite Approach LLC · Chesterfield, MON723TCWisodak Air LLC · Eau Claire, WIN724BF5904 Msl LLC · Tahoe City, CAN724CPCivil Air Patrol · Maxwell Afb, ALN724EREmbry-Riddle Aeronautical University Inc · Prescott, AZN724EWVan Bortel Aircraft Inc · Arlington, TXN724LULiberty University Inc · Lynchburg, VAN724PGL&W Leasing LLC · Murfreesboro, TNN724SPCandace A Larned Enterprises Inc · Long Beach, CAN724TMiller Neil · Plymouth, MNN7252SDorris Joseph · Lewisburg, KYN7254HVevani Aircraft LLC · Miami Gardens, FLN72559Welch Paul · Oldsmar, FLN7256DAir Supremacy LLC · Bend, ORN7256GAvstar Inc · Seattle, WAN7256HChaparral Aviation LLC · Edmond, OKN7256QAustin Ferrel Stephen · West Monroe, LAN7256WRoswall James B · Bristol, TNN7256YGupta Vivek · Shelton, CTN7257EAerospring Leasing LLC · Wasilla, AKN7257TJet & Rotor Aviation LLC · Sacramento, CAN7257ZPrivate Pilot Aircraft Rentals LLC · Sanibel, FLN72582Surdex Corp · Chesterfield, MOFirst renewal noticeN7258RMoynihan Daniel P · Hernando Beach, FLN7258ZGraber Jesse B · Northfield, MNN725BJBas Part Sales LLC · Greeley, CON725LULiberty University Inc · Lynchburg, VAN725LVAia Echo LLC · Henderson, NVN725PGPoplar Grove Airmotive Inc · Poplar Grove, ILN72608Gv Air Inc · Medford, ORN7260AChristiansen Aviation LLC · Wilmington, DEN7260HN2617f LLC · Frankfort, KYN7260KAmbitious Aviation LLC · Newport News, VAN7260QNaples Flying Club Inc · Naples, FLN72612Washington State Dept Of Transp · Tumwater, WAN72614Liberty Leasing IV LLC · Melbourne, FLN7261HMurray John Fulton III · Fort Worth, TXN7261MCox Jeff C · Newark, OHN7261ZChristiansen Aviation LLC · Wilmington, DEN72623Law Office Of Vincent G Rieger Pc · Kalispell, MTN72626Isr Platforms LLC · Mclean, VAN7262ACf Aviation Trust LLC Trustee · Wilmington, DEN7262MRegistered aircraftN7262XFlight School Of Gwinnett Inc · Lawrenceville, GAN72634Rnd Technologies LLC · Lancaster, CAN72638Dysart Jack L · Steamboat Springs, CON72639Dischler Stephen · New Lisbon, WIN72647Awa Tupua LLC · Brambleton, VAN7264DGravity & Grace LLC · Mill Valley, CA
Back to AD 2003-24-13