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.
N319EPEpic Aviation Inc · New Smyrna, FLN319KSFvx Research · Manassas, VAN319MEN319me LLC A Series Of Aero Lease LLC · San Antonio, TXN31ABEtanrith Consulting LLC · Sheldon, SCN31CWVolar III LLC · Edmond, OKN31DGGrommeck Aviation LLC · Steamboat Springs, CON31MJN31mj LLC · Naples, FLN31PLGorum Michael Wren · Red Lodge, MTN31SJCpc Aviation LLC · Algona, IAN320MECall The Ball Aviation LLC · Phoenix, AZN320RCEastern Properties LLC · Burlington, NJN320SCEcho Aviation LLC · Oregon City, ORN320SPLundstrom Aviation LLC · Ankeny, IAN321CTFox Leasing Group LLC · Hollywood, FLN321DKTwi Air LLC · Picayune, MSN321EPEpic Aviation Inc · New Smyrna Beach, FLN321GW321gw LLC · Chico, CAN321HWVan Andel Lambert J Jr · Coopersville, MIN321MECounty Of Henrico Virginia · Henrico, VAN321PWSquaw Valley Air Force LLC · Reno, NVN321WFWings Over Texas Holdings LLC · Denton, TXN322CSGlembot Troy M Trustee · Winchester, VAN322EPEpic Aviation Inc · New Smyrna Beach, FLN322JWBravo Aircfraft LLC · Alpharetta, GAN322MMRiver Transport LLC · Redlands, CAN322TEEschmann Tim · Novinger, MON323CPCivil Air Patrol · Maxwell Afb, ALN323JHThree Juliet Hotel LLC · Los Altos Hills, CAN323LPRkt Productions · Manassas, VAFirst renewal noticeN323RTRoyal Blue LLC · Franklin, TNN323YFYoo Investments Inc · Pharr, TXN324BKing Ag Leasing Inc · Sudan, TXN324CPCivil Air Patrol · Maxwell Afb, ALN324MGSilver Eagle II LLC · Carson City, NVN324RPClear For Take Off LLC · Burlingame, CAN324SMMaverick II LLC · Midvale, UTN324SPHagele Aviation LLC · Hillsboro, ORN325LCCervantes-Galdeano Lorenzo · Ingalls, KSN325MMBirdie Aviation LLC · Marble Hill, GAN325SPTfs Air LLC · Loveland, CON325SWSheroyair LLC · Sarasota, FLN3261MDyas Chris · Fairhope, ALN3265AMustang Sally Aviation LLC · Camden, SCN326CFWestbank Fishing LLC · Kiln, MSN326EPEpic Aviation Inc · Denison, TXN326LPVista Aviation Inc · Pacoima, CAFirst renewal noticeN326MCJ&D Petroleum · Tallahassee, FLN326MEAiry LLC · Seattle, WAN326PSPsl Surveys · Greenville, DEN326UWForemost Well Service LLC · Dickinson, ND
Back to AD 2003-24-13