AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N7099MLake Rodney D · Alturas, CAN7099TDls Aviation LLC · Missoula, MTN7099XCornell Donald E · Turner, MTN709LCN709lc LLC · Orange, TXN70BLJohnson Lynn O · Nome, AKN70DKParmley Terry R · Michigan City, INN70EZWood James David · Mineral Bluff, GAN70GAAmerican Airpower Heritage Flying Museum Inc · Dallas, TXN70MSWatts Keith R · Chapel Hill, TNN70RQHarbin Elbert W Jr · Dora, ALN70RSStriplin James R Jr · Hartford, ALN70RTCurtis Robert W · Sikeston, MON7100ANoel Roberto Vallejo LLC · Orem, UTN7100HSmith Marcus · Roxboro, NCN7100TDillman Robert F · Suffolk, VAN7100XSale Reported · Lincoln University, PASale reported, canceledN71014Hofmann John M · Columbus, WIN7101AChickasha Wings Inc · Chickasha, OKN7101SCuellar Lauren · Eagle River, AKN7101XKountz Joseph P · Whitehall, MTN7103ACady Marshall J · Seadrift, TXN7103HStevenson George R III · Howard City, MIN7103SHammerstrand John L · Alpine, CAN71048Hoover Michael B · Ridgeland, WIN7104SHelm Richard A · Buckeye, AZN7105ADunkley Judith A · London, OHN71060Drain Frank R · Urbana, OHN71061Hartfield George D · Lafayette, LAN71079Mcarthur William B II · Swifton, ARN7107ASlingerland Rex · Grand Haven, MIN7107FPoe John B Jr · Port Orange, FLN7107GSkyward Aviation LLC · Westborough, MAN7107MRussell Dale Christopher · Sierra Vista, AZN7107TRaetzke Bradley · Columbus, OHN7107XPowell L Alvin · Caldwell, IDN71081Cozad Charles E · Big Lake, AKN71085Tgp Aviation Services LLC · Peyton, CON7108SChapman Gary M · Sagle, IDN7108XCortez Nelly · Ontario, CAN71094Flea Market 13 And Antiques · Pocomoke, MDN71097Perry James D · Monroe, WAFirst renewal noticeN71098Cox William Cleveland IV Trustee · Shallotte, NCN7109MFlathead Flying Inc · Bigfork, MTN7109TOwens Emmett E · Madison, INN710DHSteen Valerie E · Cresson, TXN710NSo I Send You LLC · Cheyenne, WYN7111Tolleson Mell S III · St Simons Island, GAN71116Chandler Robby L · New Hope, ALN7111ABurgess Fred P · Titusville, FLN7111MPlatt Aaron Eugene · Heppner, OR
Back to AD 94-05-05 R1