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.
N653WWBerry Aviation Inc · San Marcos, TXN65411Simmons Guy M · Paso Robles, CAN65413John Mccaskill Enterprises LLC · Tifton, GAN65431Caliber Capital Holdings LLC · Homosassa, FLN65445International Air Services Inc Trustee · Carson City, NVN65447Maxxum Financial Group Inc · Destrehan, LAN65452Jf Aviation LLC · Minot, NDN6545365453 LLC · Blaine, MNN65459Vitatoe Industries Inc · Chillicothe, OHN65471Overland Aviation LLC · Williston, NDN65472Registered aircraftN65474Tk Leasing Lc · Fruit Heights, UTFirst renewal noticeN65499Pacific Quality Controls Inc · Wrightwood, CAN654CSCharlies Angel LLC · New Castle, DEN654NDInternational Air Services Inc Trustee · Carson City, NVN654PAPurdue Aviation LLC · West Lafayette, INN654PWParham Phillip · Ringgold, GAN654SPJm Air Holdings LLC · Stevensburg, VAN654TCBrocchini Christopher R Trustee · Sacramento, CAN654ZZarmada LLC · Issaquah, WAN65501Right Rudder Arizona LLC · Litchfield Park, AZN65504Bg Ip LLC · Saratoga, CAN65507Cora & Associates LLC · Norcross, GAN65512Wiebe Van Michael · Filer, IDN65514Vogt Gregory A · Broken Arrow, OKN65515Peterson Darren · Janesville, WIN65537Aces High Aviation LLC · Long Beach, CAN65557Classic Aircraft LLC · South Bend, INN65567Skylane Sky LLC · North Palm Beach, FLN65575Flight Training Aircraft LLC · Wilmington, DEN6558EZata Group LLC · North Little Rock, ARN655CPCivil Air Patrol · Maxwell Afb, ALN655EREmbry-Riddle Aeronautical University Inc · Prescott, AZN655NDInternational Air Services Inc Trustee · Carson City, NVN655PDJls Aviation LLC · Sarasota, FLN65602Ballew James H · Las Vegas, NVN65616B&M Aircraft LLC · Mission, TXN65618Glass Christopher Matthew · Mc Ewen, TNN65637N65637 LLC · Manassas, VAN65638Mid Continent Aircraft Corp · Hayti, MON65641Lexington Flying Club Inc · Lexington, KYN65647Jmc Aviation LLC · Santa Rosa, CAN65664Southwest Flying Club Inc · The Woodlands, TXN65672Jensen Thomas · Nixa, MON656CBUniversity Of Central Missouri · Warrensburg, MON656CPCivil Air Patrol · Maxwell Afb, ALN656EREmbry Riddle Aeronautical University Inc · Prescott, AZN656FCFlorida Department Of Agriculture & Consumer Svcs · Tallahassee, FLN656MAWings Over Texas Holdings LLC · Denton, TXN656SPChristiansen Aviation LLC · Wilmington, DE
Back to AD 2003-24-13