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.
N57MRTarriance LLC · Minnetonka, MNN57UDAlf Ix LLC · Chicago, ILN580CCTexas Co Title Inc · Big Spring, TXN580CPCivil Air Patrol · Maxwell Afb, ALN580DDDarling John B II · Dedham, MEN580ETTrede 2023 LLC · Castle Rock, CON580GBAcme Aviation LLC · Helena, MTN580HRValiair Limited Company Trustee · Casper, WYN580RWTelesport Aviation LLC · Wilmington, DEN580TF1294 Transportation Corp · Speonk, NYN580WAWipaire Inc · South St Paul, MNN580WBValiair Limited Company Trustee · Casper, WYN580XXSnoopy LLC · Kalispell, MTN582CPCivil Air Patrol · Maxwell Afb, ALN582LPCape Island Aviation LLC · Millville, NJN582SPSvanberg Craig Emile · Dayt Bch Sh, FLN582TCBreak For It Aviation LLC · Draper, UTN583EDEast Demarco Aviation LLC · Dallas, TXN584LQAir Shares LLC · Casper, WYN584SPTexas State Technical College At Waco · Waco, TXN585AMPj Aviation LLC · Richmond Hill, GAN585CPCivil Air Patrol · Maxwell Afb, ALN585MMN585mm Inc Trustee · Wilmington, DEN585RDBravo Aircraft LLC · Alpharetta, GAN586CPCivil Air Patrol · Maxwell Afb, ALN586JCAlcyone Trust Corp Trustee · Wichita, KSN586MCJoselt Air LLC · Lithonia, GAN586TMReimer Michelle A · Shady Shores, TXN587ERTextron Aviation Inc · Wichita, KSN587SPPinnacle Aviation Services Inc · Encinitas, CAN5880KCjc LLC · Syracuse, UTN588DCDynoair LLC · Watertown, SDN588ERTextron Aviation Inc · Wichita, KSN588TTPeltonen Christer · Moorpark, CAN589CPCivil Air Patrol · Maxwell Afb, ALN589JLHaynes Ricky L · Knoxville, TNN589RTPoling George T · Clayton, NMN589SPHillsboro Aero Academy LLC · Hillsboro, ORN58BVVarney Aviation LLC · Bangor, MEN58CR7192 Locke Road LLC · Millington, TNN58EBConservation Flight LLC · Bronx, NYN58ECFlying Pepperoni LLC · Johnston, IAN58FFWingsleasing LLC · Wichita, KSN58TJTjh Management LLC · Midland, TXN590CPCivil Air Patrol · Maxwell Afb, ALN590MMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN590SPTubreaux Aviation Services LLC · Shreveport, LAN5910TVriesenga Todd · Rockford, MIN5918DSkywalker Air LLC · Bellingham, WAN5918GLeach Jeff · Kirkland, WA
Back to AD 2003-24-13