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.
N942EHHeritage Aviation Management Ltd · Conroe, TXN942FAPropability One LLC · Daytona Beach, FLN942RBJf Aviation LLC · Minot, NDN9433RTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9435ZChristiansen Aviation LLC · Wilmington, DEN943CPCivil Air Patrol · Maxwell Afb, ALN943GCAccelerated Aviation LLC · Lugoff, SCN943SPLittle Airplanes LLC · Aurora, ORN943THSpirit Aviation Management Services Inc · Thomson, GAN943ZAHowie Express LLC · Highland, MIN94405Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN9441ZTjb Capital LLC · Nashville, TNN94461Daytona Aircraft Leasing LLC · Daytona Beach, FLN9446PPierce County Sheriffs Department · Puyallup, WAN9448ZAmeriflyers Of Florida LLC · Addison, TXN944AAWings Over Texas Holdings LLC · Denton, TXN944EREmbry-Riddle Aeronautical University · Daytona Beach, FLN944KCMustang Sally Aviation LLC · Camden, SCN944LAMindy Limited LLC · Muscatine, IAN944THSouthern Sky LLC · Henderson, NVN944TTSoutheast Aircraft Leasing LLC · Jacksonville, FLN9453ZMoody Bible Institute Of Chicago · Spokane, WAN9457TBaldwin Jeffrey K · Morristown, TNN9459CFlight Trainer LLC · Wilmington, DEN945CPCivil Air Patrol · Maxwell Afb, ALN945EBFlying Z LLC · East Lansing, MIN945FGRidgeline Assets LLC · Wilmington, DEN945GPrimewings Holdings LLC · Sunnyvale, CAN945JAPlane Fun Inc Tr Trustee · Snellville, GAN945MCPacific Northwest Aircraft Leasing Inc · Meridian, IDN945PDHickmott Mark T · Sunol, CAN945SAJahawk Leasing LLC · Sugar Grove, ILN945XPeraton Services LLC · Bozeman, MTN94618Flight Trainer LLC · Wilmington, DEN94631Flight Trainer LLC · Wilmington, DEN9463LFlight Trainer LLC · Wilmington, DEN9466XFlight Trainer LLC · Wilmington, DEN94682Flight Trainer LLC · Wilmington, DEN946CAEquity Ventures II LLC · Brighton, CON946CPCivil Air Patrol · Maxwell Afb, ALN946THWingsleasing LLC · Wichita, KSN9472FJunell Sonny Brian · Midlothian, TXN9473ZGoldstein Jeffrey Edward · Dix Hills, NYN9475FLewis Steve · Canyon, TXN9476FF & M Miya LLC · Hanford, CAN947AFAmeriflyers Of Texas Inc · Addison, TXN947BHMc Aviation LLC · Homer Glen, ILN947CPCivil Air Patrol · Maxwell Afb, ALN947VATextron Aviation Inc · Wichita, KSN9481TGpi Geospatial Inc · Orlando, FL
Back to AD 2003-24-13