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.
N7341TG & D Holdings LLC · Provo, UTN7342ANewberry Ernest B Jr · Crawfordville, FLN7342TKeyes George E Jr · Moab, UTN7343ACheek Kenneth W · Yadkinville, NCN7343MSheets Laura J · Follett, TXN7343XEnyart Patrick · Lindlakes, MNN7344MKiever Robert P Jr · Summerfield, FLN7344XOff LLC · Lonoke, ARN7345XStraytail150 LLC · Minneapolis, MNN7346THalford Richard W · Eagle River, AKN7347ATalkeetna Build A Plane Inc · Talkeetna, AKN7348MCrosby Anthony Brian · Devine, TXN7349ANorwood Brian B · Conway, ARN7349TOsipov Vladimir A · Charlotte, NCN7349XYaksh Haley · Tampa, FLN7350MPacific Valley Aviation Inc · Arbuckle, CAN7351ALandis Aviation Inc · Valdosta, GAN7351MLowder Grady L · Newport, NCN7352ABotts Benjamin R · Ketchikan, AKN7352MHamilton Dirk E · Bryant, ARN7353MWow Construction Inc · Ingleside, TXN7353TFlyit LLC · Camas, WAN7353XLopez Jhoan Steven · Miami, FLN7354TAching Raul E · Yuma, AZN7354XMartin Veronica S · Dover, DEN7355AOwens Duane Curtis · Spirit Lake, IDN7355XNorman Robert Alan · Zanesville, OHN7356ALittrell Thomas W · Galax, VAN7357AHultquist David D · Anchorage, AKN7357XBurbeck Nathan J · Fort Bragg, CAN7358AWells Jason T · Mt Hood Prkdl, ORN7359HAnderson Neil · Spring Grove, ILN7359XLawson William L · Decatur, MIN7360ABurton Justin Blake · Jenks, OKN7360TSoper Phyllis D · San Mateo, CAN7360XHimwich Elizabeth W · Bethesda, MDN7362AParker Brian A · Waco, TXN7362MFallis James B III · Wichita, KSN7362PMead Gary M · Lubbock, TXN7362TSwanson Michael J · Wayzata, MNN7363AF D P Aviation Inc · Irwin, PAN7363TGilliland Rocky · Deport, TXN7364ACerullo Joe A · Oak Harbor, WAN7364MFrahm Lon R · Colby, KSN7365ACable Philip L · Cable, WIN7365DHastings Heidi Rachelle · Wasilla, AKN7365MDanieli Barry B · El Verano, CAN7365TCrowell David P · Plainfield, MAN7367AMatlock Dianne J · East Lansing, MIN7367MSandoz Rodney A · Chadron, NE
Back to AD 94-05-05 R1