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.
N66046Palm Beach Flight Training Corp · Lantana, FLN66068Phoenix East Aviation LLC · Daytona Beach, FLN66070Obetz Robert S · Manheim, PAN66083Bravo Zulu Aviation LLC · Torrance, CAN66085Bellers Aviation Inc · Fremont, CAN660EREmbry-Riddle Aeronautical University Inc · Prescott, AZN660JWLearning 2 Fly LLC · Cave Creek, AZN660SPRobert Devers Solutions · Hermosa Beach, CAN660TJmta Management LLC · Clinton, MON66100Pj Aviation Holding LLC · Eden Prairie, MNN66104Rhb Aviation LLC · New Orleans, LAN66135Miller Robert · Pierpont, OHN66145Liberty Dog Holdings LLC · Tallahassee, FLN66175Stohlquist James R · Alamosa, CON66177Newman Ken · Hood River, ORN66184Sec Fl Corp · Santa Rosa Beach, FLN661EREmbry Riddle Aeronautical University Inc · Prescott, AZN661HPMotorcarlease USA Inc · Miami Beach, FLN661MCSteger Holdings LLC · Georgetown, TXN661PC661pc LLC · New Rockford, NDN661SPIllinois State Police · Springfield, ILN661TW12wam25 LLC · Helena, MTN662CPCivil Air Patrol · Maxwell Afb, ALN662EREmbry-Riddle Aeronautical University Inc · Prescott, AZN662SPCessna N662sp LLC · Duluth, GAN662TMUpright Corp · Kentfield, CAN663CPCivil Air Patrol · Maxwell Afb, ALN663SPN663sp LLC · Stuart, FLN663TMAir Freeman LLC · Boca Raton, FLN664CAChristiansen Aviation LLC · Wilmington, DEN664CPTextron Aviation Inc · Wichita, KSN664EREmbry-Riddle Aeronautical University Inc · Prescott, AZN664PBThomas Anthony Robert Jr · Frederick, MDN664TMPowell Michael F Trustee · Yerington, NVN665BCrosby Aviation LLC · Bend, ORN665BAGroganaire LLC · San Angelo, TXN665CPCivil Air Patrol · Maxwell Afb, ALN665CSPurdue Aviation LLC · West Lafayette, INN665HCHenrico County · Henrico, VAN665PWValiair Lc Trustee · Casper, WYN665RTN665rt LLC · Palm City, FLN665TATerry Canales Attorney At Law Pllc · Edinburg, TXN667BLClover Park Technical College · Lakewood, WAN667CPCivil Air Patrol · Maxwell Afb, ALN667EREmbry-Riddle Aeronautical University Inc · Prescott, AZN667SPHindi David · Cupertino, CAN66888Registered aircraftAssigned (import), pending cancellationN668CSTom Wood Aviation · Fishers, INN668EREmbry-Riddle Aeronautical University Inc · Prescott, AZN669DBEmpire Charters LLC · Ocala, FL
Back to AD 2003-24-13