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.
N620ZJStrategic Investment Counsel Corp · Richardson, TXN6210VEgnatchik James · Orchard Park, NYN6210YBddixon Aviation LLC · Springfield, MON6210ZKatawba Eagle LLC · Lancaster, SCN6213CMacadam Aviation LLC · Henderson, CON6213LMeh Air LLC · Benton, ARN6214NLamplighter82 LLC · Seguin, TXN6217NXing Kong Aviation Service LLC · Atwater, CAN6217QZulu Kilo LLC · Seven Valleys, PAN6218BBrant Air LLC · Davidsonville, MDN62199Aircraft Guaranty Corp Trustee · Oklahoma City, OKN621CLN621cl LLC · Overland Park, KSN621DAdams Consulting & Programming Inc · Quincy, ILN621MCDr Carlton J Lewis And Nina Lewis Family Lp · Lufkin, TXN621PMAtp Aircraft 1 LLC · Wilmington, DEN621TCsa Aircraft Leasing LLC · Salt Lake City, UTN62245Gabrieles Wings LLC · Oldwick, NJN62276Harris Steven E · Steamboat Springs, CON6228NGreenwich Venture Partners LLC · Greenwich, CTN6229QChristiansen Aviation LLC · Wilmington, DEN622CMMcgill Charles · Sunriver, ORN622EFEpic Aviation Inc · New Smyrna Beach, FLN622FHNational Aircraft Leasing Corp · Greenville, DEN622KCAir Burt LLC · Rochester Hills, MIN622WBRegistration Pending · Missoula, MTRegistration pendingN6235TCrystal Air Inc · Chattanooga, TNN6236MJlkd LLC · Lewes, DEN6238AExecutive Flight Institute LLC · Murrieta, CAN623DWHtft LLC · Las Vegas, NVN623EREmbry-Riddle Aeronautical University Inc · Prescott, AZN623HBRidgeline Assets LLC · Wilmington, DEN623KWLanier Equipment Leasing LLC · Gainesville, GAN623RTTextron Aviation Inc · Wichita, KSN623SPAtp Aircraft 2 LLC · Wilmington, DEN623UTTextron Aviation Inc · Wichita, KSN62404Tech Flyers LLC · Asheville, NCN6240JJw2bar Montana LLC · Bozeman, MTN6241BAces Aviation LLC · Awendaw, SCN6241ZVan Bortel Aircraft Inc · Arlington, TXN6242FAzul Services LLC · Bozeman, MTN6245BInternational Air Services Inc Trustee · Carson City, NVN6245CWings Over Texas Holdings LLC · Denton, TXN6245EDirty Side Down Aviation LLC · Georgetown, TXN6245NRoy Robert William · Cumming, GAN6245XWarrington Flying Club Inc · Doylestown, PAN6247CSan Simeon Air LLC · San Francisco, CAN6248SValiair Limited Company Trustee · Casper, WYN624BBravo Aircraft LLC · Alpharetta, GAN624CFCorona Jose Jr · Corona, CAN624MAVotaw Michael · Wilton, CA
Back to AD 2003-24-13