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.
N7829EHochstatter Pat J · Moses Lake, WAFirst renewal noticeN7829TDampier William · Greenwood, INN7829XObservation Corp · Newark, CAN7829ZMclaughlin Dustin T · Abilene, KSN78300Plane Fun Inc Tr Trustee · Snellville, GAN7830TWalker Homes LLC · Stratford, OKN7830UObrien Cornelius R · Sellersville, PAN7830ZFlanary Kenneth Mitchell · Five Points, ALN78310Huang Sophie M · Newcastle, WAN78311Rey Henry R · Fresh Meadows, NYN78314Stinton Jacob Merle · Palmetto, FLN78315Breese William R · Omaha, NEN78316Christiansen Lance W · Anacortes, WAN78317Silveria Frank R · Los Banos, CAN7831AZollitsch Allan P · Lancaster, NYN7831FHallmark Ryan M · Vidor, TXN7831UHerrin Thomas · Patterson, GAN7831XChupka Kris W · Golden, CON78320Zoom Leasing LLC · Barto, PAN78321Yak Training LLC · Mansfield, TXN78324Langman Greg K · Manitowoc, WIN78325Dooley David C · Erie, CON78326Gregg Delvin K · Durango, CON78328Bucklar Construction Co · La Quinta, CAN7832TN7832t LLC · Wilmington, DEN7832UFly 32u LLC · Monroe, NCN7832ZArnold Mark D · Holloway, MNN7833EChecky Allan O Jr · Merrimac, WIN7833MFoote Lori A · Decherd, TNN7833TJohnson Spring M · Wortham, TXN7833ULfs Inc · Gillette, WYN7834TYturri David P · Marble Falls, TXN7834USirens Call LLC · Nashville, TNN7834ZRall Jared W · Williamsport, PAN7835EUnternaehrer Robert U Trustee · Brunswick, MON7835JCornwell Jerry T · Mc Alpin, FLN7835TRound Engine Aero · Nashville, MIN7835UEyrie Aviation LLC · Suwanee, GAFirst renewal noticeN7836KKennedy Brent Robert · Anchorage, AKN7836XOsage Aviation LLC · Yates Center, KSN7836ZSpartan National Holdings LLC · Missoula, MTN7837FObrien Daniel N Jr · Bellevue, WAN7837UCommander Aviation LLC · Monroe, MIN7837ZBouvier Louis M III · Monticello, UTFirst renewal noticeN7838FMcdonald Air Services LLC · Saint Johns, MIN7838ZMonnig Hans J · Westerville, OHN7839XBedsole Jerry L · Elba, ALN7840UKay Bennie L · Brigham City, UTN7840ZHorak Mark E · Valencia, CAN78416Sands Donald · Lafayette, LA
Back to AD 94-05-05 R1