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.
N309SPSchaumburg Flying Club Nfp · Palatine, ILN309TXCareer Track 2 LLC · Wilmington, DEN30SUOhio State University · Columbus, OHN30TLElite Approach LLC · Chesterfield, MON30YPBmf Jax LLC · Jacksonville, FLN30YRInn Flying Club Inc · Gaithersburg, MDN311AMBarr Air Patrol LLC · Mesquite, TXN311HPOhio Department Of Public Safety · Columbus, OHN311JMN311jm LLC · Lake City, FLN311KPPickard Kevin P · Washington, MIN311SBNbr Aviation · Manassas, VAFirst renewal noticeN311TGTg Air LLC · Fishers, INN312KKHowser Donald Marvin III · Granbury, TXN312PDValdosta Flying Service Inc · Valdosta, GAN312RMSunny Days Prop Jox LLC · Niceville, FLN312XYAir Surgeon I LLC · Miami, FLN313AAAviator Air Operations LLC · Grand Prairie, TXN313CPCivil Air Patrol · Maxwell Afb, ALN313ECCunha Properties Management LLC · Miami, FLN313MAAbrams David · Holmdel, NJN313RMVan Bortel Aircraft Inc · Arlington, TXN313YZTextron Aviation Employees' Flying Club Inc · Wichita, KSN3144VMike Smith Aviation International Inc · Napa, CAN314FRHawkeye Helicopter LLC · Lyndon, KSN314LARaintree Aviation LLC · Mesa, AZN314MEJfw Ranch Consulting LLC · Albuquerque, NMN314RARochester Air Center LLC · Canandaigua, NYN314SAAeryn Innovations LLC · Dallas, TXN315DMSpartan Education LLC · Tulsa, OKN315GFCommander Aviation LLC · New Holland, ILN315MEBlue Horizons Flying Club Inc · Perrysburg, OHN315SFSnohomish Flying Service Inc · Snohomish, WAN315SKOklahoma Aviation LLC · Bethany, OKN315TPN315tp LLC · Stuart, FLN316ADRude Daniel · Leesburg, VAN316ASChristiansen Aviation LLC · Wilmington, DEN316DCAb Prop Plane II LLC · Metairie, LAN316EPMustang Sally Aviation LLC · Camden, SCN316HCChilders Henry Dr · Lewes, DEN316JHNorthern Arizona Investment Group LLC · Prescott, AZN316RBRbp Management LLC · Franklin, NCN317BLCowboy Aviation LLC · Edmond, OKFirst renewal noticeN317BTAmerican Aircraft Brokers LLC · Aurora, ORN317CPCivil Air Patrol · Maxwell Afb, ALN317HDHardrock Drilling LLC · Francesville, INN317MSHolley Melissa T · Baton Rouge, LAN318LLLee Aviation Services LLC · Wilson, NCN318SJObr Leasing · Manassas, VAFirst renewal noticeN318WCDelta Dusters LLC · Lake Providence, LAN319CSRas Airways LLC · Garland, TX
Back to AD 2003-24-13