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.
N346BSGulf Coast Aviation LLC · New Orleans, LAN346CACivil Air Patrol · Maxwell Afb, ALN346CKCk Contracting Inc · Kings Mountain, NCN346CPPinnacle Aviation Services Inc · Encinitas, CAN346JHRobertson Timothy A · Lewistown, MTN346KMitchell Flying Club Inc · Lees Summit, MON346SPFlightline Air Service LLC · Pineville, LAN347LSEuroaviation Inc · KematenN347MENiemeyer Leasing LLC · Cave Creek, AZN347SACoastal Carolina Helicopters LLC · Burgaw, NCN348CPHaddock Tracey P · Kingstree, SCN348MTextron Aviation Inc · Wichita, KSN348MEBlackstone Aviation LLC · Irvine, CAFirst renewal noticeN348SPSilverhawk Aviation Academy LLC · Caldwell, IDN348TCWilliams Ryan D · Panama City, FLN349CPCivil Air Patrol · Maxwell Afb, ALN349MEPlane Nonsense Inc · Middletown, DEN349PSBrowning Amy S · Knoxville, TNN349SPWard Michael Allen · Quinlan, TXN34BLAmerican Asset Leasing LLC · Aurora, ORN34GSGhavi Enterprises Inc · Kenosha, WIN34LGCruz Aviation LLC · Holmdel, NJN34PLMoonglow Aviation LLC · Toledo, OHN34UMMarathon Skylane LLC · West Palm Beach, FLN3500FN3500f LLC · Jennings, LAN3500MNagy Sandor · Monterey, CAN3500RSystems Research Corp · Wilmington, DEN3500TSusanville Aviation LLC · Susanville, CAN35014Trionz LLC · Artesia, NMN3501K3501k LLC · Southaven, MSN3501RStanislaus County Sheriffs Department · Modesto, CAN3502JAv Solutions Inc · Flint, MIN3502QHarvest Aviation LLC · Yorba Linda, CAN3503HRansom Woodbury S Trustee · Lansing, IAN3504PWingsleasing LLC · Wichita, KSN3505TAa-Aero Inc · Fairfield, NJN35063Purdue Aviation LLC · West Lafayette, INN3506GDelta State University · Cleveland, MSN3506HHorn Marcia L · Erie, CON3506QEjair LLC · Shelburne, VTN3506TBaron Logistics LLC · Metairie, LAN3506YCascade Commodities LLC · Saint Paul, MNN35077Carreno Victor A · Guaynabo, PRN35079Wings Over Texas Holdings LLC · Denton, TXN3508JDhs Operations LLC · Wilmington, DEN35092Iasco Flight Training Inc · Redding, CAN3509QChristiansen Aviation LLC · Wilmington, DEN350EREmbry-Riddle Aeronautical University Inc · Prescott, AZN350SUOhio State University · Columbus, OHN35106Bradley Patrick C Trustee · Isleton, CA
Back to AD 2003-24-13