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.
N21339Pilots Flying School LLC · Englishtown, NJN2133LGietzen Jeff · Seattle, WAN2134MChristiansen Aviation LLC · Wilmington, DEN21359Aircraft Guaranty Corp Trustee · Oklahoma City, OKN2135DN2135d LLC · Eustis, FLN2135KJet Air Inc · Iowa City, IAN2135SEastern Cincinnati Aviation Inc · Batavia, OHN21369Smk Holdings LLC · Sandy, UTN2137H3 Pandas LLC · Farmington, NMN2138BSouthwest Aviation Enterprises · Haslet, TXN2138WChristiansen Aviation LLC · Wilmington, DEN21394Long Island Aviators LLC · Seaford, NYN2139UJust Plane Stuff Inc · Jackson, MSN213AAAir Mac Ventures LLC · Houston, TXN213CMBollingberg Kurt O · Cathay, NDN213GGShortcut LLC · Kihei, HIN213LPT31 Aviation LLC · Dallas, TXN213NBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN213SMArrowhawk Imaging LLC · Morgantown, WVN21413Botwinick Jeffrey Richard Patrick · Syracuse, NYN2141DFoturis Inc · Kingston, PAN2141YAnson Air LLC · Sugar Land, TXN2142SDbm Farms Inc · Clarksdale, MSN2144VAnson Air LLC · Sugar Land, TXN21454Textron Aviation Inc · Wichita, KSN2145JSchool Of Missionary Aviation Technology · Ionia, MIN2145RCabernet To Cactus LLC · Scottsdale, AZN2145TCff Air Inc · Wilmington, DEN2145ZTextron Aviation Inc · Wichita, KSN2146AZhukov Igor · Live Oak, FLN2146CVan Bortel Aircraft Inc · Arlington, TXN21483Lima-001 LLC · Muscatine, IAN2148WSav LLC · Shelton, WAN21493Macmillan Robert J · Merritt Island, FLN214BKS&N Pearl LLC · Port Orange, FLN214CFKlug Air LLC · Wilmington, DEN214FAGeorgia Forestry Commission · Macon, GAN214GCCloud Robert Trustee · Kerrville, TXN214GZAerospring Leasing LLC · Wasilla, AKN214LE3 Weens LLC · Hoschton, GAN214MHShadow Ventures LLC · Chesapeake, VAN214VWMilford Aviation LLC · Greensburg, INN2150GMsb Aviation LLC · Rockvale, TNN2150KCarey David John II · Mccall, IDN2151XWcps Aviation LLC · Marietta, GAN2151YMtjc Services LLC · Chester, WVN2152KSkylane Flights LLC · West Palm Beach, FLN2152SMoore Aviation Inc · Beaver Falls, PAN2152VJameson Paul E · Palm Coast, FLN2153AAcuna Edward DBA · Pearland, TX
Back to AD 2003-24-13