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.
N68BKKrauch William K Co-Trustee · Santa Ynez, CAN68CEEbright Inc · Stateline, NVN68DSSichak Stephen Jr · Wanaque, NJN68FFPeregrine Howard Partners II Lp · New Orleans, LAN68KWKim Waters Inc · Gainesville, GAN691JATextron Aviation Inc · Wichita, KSN691SPGc Aviation Services-1 LLC · Miamisburg, OHN691TCSpartan National Holdings LLC · Missoula, MTN6929JMhz5620 LLC · Fitchburg, WIN692CPCivil Air Patrol · Maxwell Afb, ALN692SPSmith Holdings Inc · Wilmington, DEN693SACaddo Aircraft LLC · Lewes, DEN694BWOtter Creek Aviation LLC · Columbus, GAN694CPCivil Air Patrol · Maxwell Afb, ALN694RJAtlas 182rj LLC · Port Townsend, WAN694SAMile High Ventures Inc · Palm Harbor, FLN694SCAlpha Charlie Aviation LLC · Oregon City, ORN694SMSurveying And Mapping LLC · Austin, TXN694SPFox Leasing Group LLC · Hollywood, FLN694TCBruton Aerial Spraying Inc · Garden City, TXN695CPCivil Air Patrol · Maxwell Afb, ALN695SPJet Air Inc · Iowa City, IAN696EAHubbard Broadcasting Inc · Saint Paul, MNN696SAThree Green Aviators LLC · Midland, TXN697CPCivil Air Patrol · Maxwell Afb, ALN697EFElam Nathan A · Hereford, TXN698JABon Bon Aviation LLC · Daly City, CAN698MCRegistered aircraftN698SPFoothill Aircraaft Sales & Service Inc · Upland, CAN699AWTextron Aviation Inc · Wichita, KSN699CBBig Skylands Aviation LLC · Succasunna, NJN699CPCivil Air Patrol · Maxwell Afb, ALN699LPFrg III Inc DBA · Lincoln Park, NJN69CPBuena Vista Hunting LLC · Eagle Pass, TXN69JYInternational Air Services Inc Trustee · Carson City, NVN6HPState Of Ohio · Columbus, OHN6HTColorado By Air LLC · Salida, CON6TSRd Leasing LLC · Salem, ORN700HWHotel Whiskey LLC · Sylvania, OHN700PMRar LLC · Louisville, KYN701FASkylane Flyers LLC · Fort Mill, SCN701LULiberty University · Lynchburg, VAN701SPScandinavian Aviation Academy Inc · El Cajon, CAFirst renewal noticeN702CPCivil Air Patrol · Maxwell Afb, ALN702GRAir America Flight Center LLC · Daytona Beach, FLN702LULiberty University · Lynchburg, VAN703BFTextron Aviation Inc · Wichita, KSN703BKKenzy 2023 LLC · Castle Rock, CON703CMSeneca Structural Engineering Inc · Irvine, CAN703CPCivil Air Patrol · Maxwell Afb, AL
Back to AD 2003-24-13