AD 96-10-01 R1
Registered aircraft · 8,139
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:96-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1')
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:96-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1') 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.
N8283NRuth Joyce Aviation LLC · Henderson, TXN8284NHolland Alan L · Houston, TXN8284WCaldwell Darrel R · Panama City Beach, FLN8285WBas Part Sales LLC · Greeley, CON8286NAyyildiz Erol · Glen Rock, NJN8287NBetik Patrick G · Grapevine, TXN828MCHub City Aviation Academy LLC · Lubbock, TXN8290NHorne Larry E · Suffolk, VAN8290WCastles James D · Portland, ORN8291NPeters Rodney A Jr · Hayward, WIN8291WVoll Dorothe A · Corona, CAN8292WPinegar Kevin R · Brighton, MIN8293NPaul Harvey B · Kongiganak, AKN8295NMaust Philip J · Hemet, CAN8295WHess Stephen L · Millerton, PAFirst renewal noticeN8296NCline Terence P · Alva, OKN8296WAngert Phillip E · New York, NYN8297NShowman Christopher D · Frisco, TXN8297WTraxler Christopher L · Reading, PAN8300RBodner Michael J · Rock Hill, SCN8301W01w Aero LLC · Conway, ARN8302RHofmann Richard C · Keizer, ORFirst renewal noticeN8302WNaccarato Aviation LLC · Woodstock, GAN8303WIrwin Jerome C · Anchorage, KYN8304RKnots And Attitudes LLC · Wimberley, TXN8304WCassin William J · Uvalde, TXN8306CCoolidge Oliver · Downers Grove, ILN8306RPernula Jacob D · Mount Vernon, WAN8307RKlingerman Chester E Jr · Plymouth, INN8307WPeden Travis Austin · Sheridan, WYN8308RClassic Flyers Club Inc · Hastings, NEN8308WSchlenker Richard A · Meeteetse, WYN8309RPipal Cory J · Dublin, TXN830PColeman Nathan R · Zephyrhills, FLN830RCMartin Douglas J · Lutz, FLN8310WBennett Anthony W · Bradenton, FLN8311WAlford Charles Mikael · Meadow Valley, CAN8312WGillen James A · Cornville, AZN8313WLummus Brett D · Forney, TXN8314WWingsleasing LLC · Wichita, KSN8315WJg Aero LLC · Smyrna, DEN8316CUplands Aviation Management LLC · Mineral Point, WIN8316RDelagrange Nathan A · Hicksville, OHN8318RAir Wave Holdings LLC · Porter, TXN8319WBlaker Martin O · Rough And Ready, CAN831BFHuddleston Edward L · Oaktown, INN8320WOracle Aviation LLC · Omaha, NEN8321RThompson Grady R · Athens, ALN8321WWeighman David R · Battle Creek, MIN8322WLickteig Eric Kirk Trustee · Ellensburg, WA
Back to AD 96-10-01 R1