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.
N478SPAbove And Beyond Aviation LLC · Austin, TXN479EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN479SPRegistered aircraftN47AFL & J Aviation Inc · Atwater, CAN47GFGlobal Flight Support And Sales Inc · Tampa, FLN47KMMyers Boyz Aviation LLC · Horseshoe Bay, TXN47TNFlight Operations Aircraft LLC · Wilmington, DEN480ACAdams Consulting And Programming · Quincy, ILN480ERFlying Off Leash Aviation LLC · Daniel Island, SCN480SPDhs Operations LLC · Wilmington, DEN481CPBlue Water Aviation LLC · Oakman, ALN481EREmbry-Riddle Aeronautical University · Daytona Beach, FLN481TCFargo Aviators LLC · Phoenix, AZN481WPoper Jeremy · Albuquerque, NMN4820JDraper Aviation LLC · Versailles, KYN482CACivil Air Patrol · Maxwell Afb, ALN482CGKilo Sierra Enterprises LLC · Lafayette, CON482CPCivil Air Patrol · Montgomery, ALN482CSTextron Aviation Inc · Wichita, KSN482EREmbry-Riddle Aeronautical University · Daytona Beach, FLN482SPArq Aviation LLC · Wilmington, NCN482TWT34 Mentor LLC · Saint Joseph, ILN4839TOrchard Elms LLC · North Ogden, UTN483CACivil Air Patrol · Maxwell Afb, ALN483EREmbry Riddle Aeronautical University · Daytona Beach, FLN483SPScandinavian Aviation Academy Inc · El Cajon, CAN484CACivil Air Patrol · Maxwell Afb, ALN484CSTextron Aviation Inc · Wichita, KSN484ERWisconsin Aviation-Four Lakes Inc · Madison, WIN484HRCebolla Air LLC · Camarillo, CAN484JBSilver Creek Aviation Services · Fort Worth, TXN4855PAvenger Aviation LLC · Midland, TXN485CACivil Air Patrol · Maxwell Afb, ALN485JMSanders Flight Training Center Inc · Jasper, ALN485VL & W Leasing LLC · Smyrna, TNN486CACivil Air Patrol · Maxwell Afb, ALN486CPCivil Air Patrol · Montgomery, ALN486ERUw Flying Club Inc · Sun Prairie, WIN486TCMonte D Burke · Dallas, TXN487ERCloudchasers LLC · Colorado Springs, CON487SPArchimedes Aviation LLC · Livermore, CAN488EREmbry Riddle Aeronautical University · Daytona Beach, FLN489CACivil Air Patrol · Maxwell Afb, ALN48EFVista Air Inc · Pacoima, CAN48FFWingsleasing LLC · Wichita, KSN48RGBlueskies LLC · Smyrna, TNN490CPCivil Air Patrol · Maxwell Afb, ALN490EREmbry-Riddle Aeronautical University · Daytona Beach, FLN490LLAntel Av Corp · Lewes, DEN490NWGalvin Flight Services Hawaii LLC · Honolulu, HI
Back to AD 2003-24-13