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.
N9161TMenagerie Enterprises Inc DBA · Denison, TXN9163TMcc Investments LLC · St Louis, MON916BAMaya Aircraft Holdings LLC · Lee, NHN916BQ9k Air LLC · Newark, DEN916ET9k Air LLC · Newark, DEN916FT9k Air LLC · Newark, DEN916GW9k Air LLC · Newark, DEN916HT9k Air LLC · Newark, DEN916KTPelican Flight Training LLC · San Carlos, CAN916MABusch Brett · Stanford, MTN916MCJanicke Kenneth O · Wichita, KSN916NT9k Air LLC · Newark, DEN916PBM & G Aircraft Management LLC · Aurora, ORN916QTElizabeth City State University · Elizabeth City, NCN916RR9k Air LLC · Newark, DEN916TAAtp Aircraft 4 LLC · Wilmington, DEN916UT9k Air LLC · Newark, DEN916WRPsl Surveys · Manassas, VAFirst renewal noticeN916WTRound Rock Aviation LLC · Douglas, WYN9171UAir Alpine Activities Inc Trustee · Wilmington, DEN91777Triple 7 Holdings LLC · Lewes, DEN9177VWorld Wide Life Services LLC · Short Hills, NJN917CFN917cf LLC · Tucson, AZN917CPCivil Air Patrol Inc · Maxwell Afb, ALN917MAKs Flying Club Inc · Manhattan, KSN9181PNorthwestern Michigan College · Traverse City, MIN918CMRodriguez Eduardo Urquidi · Santa Teresa, NMN918CPCivil Air Patrol Inc · Maxwell Afb, ALN918EEArchaeopteryx LLC · Harvey, LAN918KGGreasewood Ranch Aviation LLC · Midland, TXN918MYFlying Pigs LLC · Tulsa, OKN918RGG & L Equipment Leasing LLC · Natchez, MSN918TPAzure Quest LLC · Cleveland, TNN918WMStone City Charters LLC · Anamosa, IAN91920Brodel Adam · Grass Valley, CAN91934N91934 LLC · Evergreen, CON91936Oklahoma State University · Stillwater, OKN9195BSouthwest Aviation Enterprises · Haslet, TXN91966Wings Over Texas Holdings LLC · Denton, TXN9196WOklahoma State University · Stillwater, OKN9197MGlover Carl A · Albuquerque, NMN9198WOklahoma State University · Stillwater, OKN91996Oklahoma State University · Stillwater, OKN9199ZOklahoma State University · Stillwater, OKN919CPCivil Air Patrol Inc · Maxwell Afb, ALN919CWGv Air Inc · Medford, ORN919EPEpic Aviation Inc · New Smyrna Beach, FLN919MKRyan Jacqueline Lee · Bend, ORN919TAAtp Aircraft 4 LLC · Wilmington, DEN919TCD & S Aviation LLC · Spring, TX
Back to AD 2003-24-13