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.
N22055Adrian Ojeda Jr · San Ysidro, CAN2209HLynxaviation LLC · Carpinteria, CAN220CACivil Air Patrol · Maxwell Afb, ALN220CPCivil Air Patrol · Maxwell Afb, ALN220CSTextron Aviation Employees Flying Club Inc · Wichita, KSN220DETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN220WCJeffery & Weiss Holdings LLC · Long Beach, CAN2214LBlue Bird Aviation LLC · San Jose, CAN2217LInternational Air Services Inc Trustee · Carson City, NVN221DWDm Private Aviation LLC · Kaukauna, WIN221EPEpic Aviation Inc · New Smyrna Beach, FLN221GSBarientos Bryan I · Petaluma, CAN221JTThompson Joseph · Marion, INN221MEKarabin Gerald D · Vicksburg, MIN22206Slater Craig W · Brick, NJN2220YFarid Zia Physical Therapist A Professional Corp · El Centro, CAN2221RPhoenix East Aviation LLC · Daytona Beach, FLN2221XK C Leasing Corp · Woods Cross, UTN22237Aviation Training LLC · Wilmington, DEN2223UDylans Rv Center LLC · Waterford, NJN2225AFreedom Aviation Inc · Lynchburg, VAN2225FTextron Aviation Inc · Wichita, KSN22265Edb Air Inc · Wilsonville, ORN2227FBay Area Aviation LLC · Beach City, TXN2228THulsey Hunter · Madison, MSN222DCTextron Aviation Inc · Wichita, KSN222FGoddspeed LLC · Encinitas, CAN222KWHines Tommy · Calvert City, KYN222LFLunken Flight Training Center LLC · Cincinnati, OHN222MTJw182 LLC · Kalispell, MTN222VWCool Beans LLC · Newtown, PAN222XMSchlasinger Larry DBA · Chetek, WIN2231EState Of Iowa · Des Moines, IAN2231FSouthern Aircraft Consultancy Inc Trustee · Casper, WYN2233MPutnam John P · Weirsdale, FLN2234UMountain States Casing Co LLC · Timnath, CON2235VE & R Aviation Services Inc · Long Beach, CAN22373Roche Timothy P · Falls Church, VAN2237SOregon State Police · Salem, ORN223APJuliet Aviation LLC · Oregon City, ORN223BWBridgewater State University · Bridgewater, MAN223CKBounds Keith A · Thomson, GAN223EMKqm Aviation · Manassas, VAFirst renewal noticeN223HCG206 LLC · San Juan, PRN223HFHeritage Asset Leasing LLC · Ronkonkoma, NYN223JMEid Bradley · Greenwood, INN223LPChristiansen Aviation LLC · Wilmington, DEN223MEChem-Air LLC · Shreveport, LAN223TB416b Heritage Hills Dr LLC · Palm Harbor, FLN22412Time Flies LLC · Oak Brook, IL
Back to AD 2003-24-13