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.
N3635S2nd Chance Enterprise LLC · North Haledon, NJN363BLElizabeth City State University · Elizabeth City, NCN363CKAviator Air Operations LLC · Grand Prairie, TXN363CPBarr Air Patrol LLC · Mesquite, TXN363CS3tr Aviation LLC · Longview, TXN363KRegistered aircraftN363MAMuchodeanaero Inc · Wilmington, DEN363SAN363sa LLC · Stuart, FLN363SPOrange County Flight Center Inc · Santa Ana, CAN364CPBarr Air Patrol LLC · Mesquite, TXN364DRegistered aircraftN364GWHdh Aircraft Leasing LLC · Carrollton, TXN364MAJet Air Inc · Iowa City, IAN364MSSkyhawk Aviation LLC · Omaha, NEN364SAJackson Edwin W · Tampa, FLN364SPVermont Flight Academy · South Burlington, VTN365CACivil Air Patrol · Maxwell Afb, ALN365CPBarr Air Patrol LLC · Mesquite, TXN365ESLakewood Investments LLC · Victorville, CAN365MADip Aviation LLC · Fort Lauderdale, FLN365MEEhnisz Craig T · Monterey, CAN365PBTruck Force One LLC · Homestead, FLN365SPClow International Airport LLC · Bolingbrook, ILN365WCCrane Douglas F · Ukiah, CAN366CTAia Charlie LLC · Henderson, NVN366MATew Services Corp · Wilmington, DEN366METhree Six Six Mike Echo LLC · Mantua, UTN366NHState Of New Hampshire Dept Of Safety · Concord, NHN366STN366st LLC · Kenesaw, GAN367CTCoast Flight Training And Management Inc · San Diego, CAN367DKBonner Carl · Farmville, NCN367MAMindy Limited LLC · Muscatine, IAN367TWTextron Aviation Inc · Wichita, KSN367TZEquipco LLC · Kalispell, MTN368ESMindy Limited LLC · Muscatine, IAN368MState Of Montana · Helena, MTN368MEWbl Air LLC · Minneapolis, MNN369ANJet Aircraft Inc Trustee · Wilmington, DEN369BGBrantley George · Carlsbad, NMN369CPCivil Air Patrol · Maxwell Afb, ALN369CVVan Bortel Aircraft Inc · Arlington, TXN369DADuan Ran · Bothell, WAN369GCCoyote Moon Ranch LLC · Otsego, MIN369METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN369TCSchach Barbara G · Kirkland, WAN369TWChristiansen Aviation LLC · Wilmington, DEN369WPLego Aviation LLC · Grimes, IAN36ADTextron Aviation Inc · Wichita, KSN36JRCatching Freedom LLC · Bozeman, MTN36RHRobin Hood Aviation LLC · Dunn, NC
Back to AD 2003-24-13