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.
N56950Bodily Kent A · Washington, UTN56957Payne Glenn · Oregon, MON56958Jackson Michael L · Nixa, MOFirst renewal noticeN5695W95whiskey LLC · Georgetown, MAN56964Lafollette Larry E · Strafford, MON56966West David A · Astoria, ORN56970Simoneau Todd · Sandown, NHN56976Tate Bird L Jr · Hammond, NYN56977Evans Holland L · Danielsville, GAN56978Brindley James G · Collinsville, ALN56986Loya Armando · Whittier, CAN56989Kenny Zachary D · Herndon, VAN5698UNorby David S · Gooding, IDN5698WBurkett Aviation LLC · Hampstead, NCN56996Zarn Douglas J · Amboy, MNN56997Bibb John G · Paragould, ARN569FLN7396w LLC · Coeymans Hollow, NYN56WBTmr Aviation LLC · Fredericksburg, VAN5700FTubbs Arthur R · Audubon, NJN5700WViriyaphap Chattada · Birmingham, ALN5701FKaspar Roger · Aurora, ILN5701USouthern Colorado Flight Professionals LLC · Pueblo, CON57020Kerschner Ira Henry · Cochranville, PAN5702FKoza William J · Albert Lea, MNN5702UEdwardsson Axel M · Waianae, HIN5703UXcelleration Aviation Inc · Sarasota, FLN5703WKelley Keith B · Forney, TXN5704FJames Alfred F · Katy, TXN5704UZephyr Air LLC · Hickory, NCN5705FWilkinson David E · Waleska, GAN5705WSmart Avionics Inc · Marietta, PAN5706USaccento Anthony J · Binghamton, NYN5706WShick Andrew C · Grand Junction, CON5707FEure Michael T · Moyock, NCN5708UFwj Aviation LLC · Crown Point, INN5709FBitterfield Colin · Las Vegas, NVN5709UGundersen Lance · Murfreesboro, TNN5709WBrinkley Ralph L · Lexington, NCN5710FOso Air LLC · Missoula, MTN5710WOso Air LLC · Missoula, MTN5711FVoelker Steve L · Clackamas, ORN5711UBlack Cat Aviation Inc · Wilmington, DEN5712FPhil Birkelbach · Waller, TXN5712UPark Hui Nam · Buena Park, CAN5713FDufresne Justin B · San Tan Valley, AZN5714FRegistration Pending · Arlington, TXRegistration pendingN5714UTxl Consulting LLC · Hurst, TXN5715WRyan Peter C · Riverhead, NYN5716UMil2atp Inc · Pikeville, NCN5717FDanberry John Lee · Janesville, MN
Back to AD 96-10-01 R1