AD 94-05-05 R1
Registered aircraft · 26,230
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.
N8912RDay Kimberly K · Grand Rapids, MNN89134Hobson Michael W · Goodyear, AZN89139Kelp Jeanne L · Greenacres, WAN89140Walters Ryan D · Culloden, GAN89141Grover Jan L · Weatherly, PAN8914SCarroll Louis · Perris, CAN89151Margart Kristopher W · Walla Walla, WAN89152Kitts Ryan B · Fromberg, MTN89155Ely Roger J · Chandler, AZN89156Bornheber Ralf · Novi Marof-DraskovN89157Lombardi Jack D · Bronx, NYN8916BSanborn George A Sr · Culver, ORN89170Mowery Charles C · Tioga, WVN89173Cooper Matthew · Fairbanks, AKN8917BTederman Terri Lynn · Auburn, WAN8917RDyke Milo O · Hazen, NDN89189Barchik Edward C · Huntington Mills, PAN89191Simmons Steven E · Kinston, ALN89194Haley Lee · Ahwahnee, CAN89198Riggin Flight Service Inc · Madison, SDN891SROmalley Benjamin P · River Falls, WIN89200Nostalgair Sky Adventures Inc · Vero Beach, FLN89201Hangar Ak LLC · Sterling, AKN89202Kinney James R · Vermillion, SDN89205Neal Kyle · Midlothian, TXN89209Vander Veen William A · Dyer, INN8920SWefald Richard I · Jordan, MNN89211Capece Richard N · Leonardtown, MDN89213Iler Elden · Van Nuys, CAN89217Reddeck Thomas J III · Gold Hill, NCN89221Smith Fane S · Newport Beach, CAN89222Johnson Lucas · Pleasant Lake, MIN89227Koontz Rodney A · Lexington, NCN89233Sale Reported · Homer, AKSale reportedN89235Meuse Cade · Dallas, TXN8923SHuang Chen · Chino Hills, CAN89241Jackson Barry P · Paragould, ARN89244Daman Vickie L · Kasilof, AKN89249Halloran Donal Warren · Marshfield, WIN89250Lamb Colter L · Portales, NMN89252Warren Joy A · White Lake, MIN89256Liby Darren L · Hutchinson, KSN89257Mix Timothy R · Hubbard, ORN89262Gosshawk Unlimited Inc · Casa Grande, AZN89264Clydes Best LLC · Willow Springs, ILN89265Snyder Glenn N · Richardson, TXN8926BEmery Marilyn L · Randle, WAN8926SRichardson Gordon P · Polson, MTN89270Hamer Marinus P · Livonia, NYN89274Doran Jeffrey T · Westerville, OH
Back to AD 94-05-05 R1