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.
N8076FYoxtheimer David R · Mansfield, OHN8076LWay Properties LLC · Tumbling Shoals, ARN8076SChinn Thomas Blake · Arlington, TXN8076TJohnson Stephenie I · West Columbia, SCN8077ADaly William J · Minnesota Lake, MNN8077DSkyport Inc · Las Vegas, NVRevoked, canceledN8077FM-F Aviation LLC · Norman, OKN8077LAndrews Carson D · Hartsville, SCN8077SRebecca Grace LLC · Riesel, TXN80782Zahler Mitchell J · Stillwater, MNN80786Oney Marilyn S · Beach City, OHN80787York Richard Alan · Amherst, NYN8078ALeonard Willis Thomas · Vacaville, CAN8078BShareair LLC · Columbiaville, MIN8078LSale Reported · HawkestoneSale reportedN8078SBazemore Kelley R · Ingleside, TXN8078TWise James K · Billings, MTN80791Fenderson Keith Trustee · Meadow Vista, CAN80794Durham David C · Belton, SCN80795Swift Museum Foundation Inc · Athens, TNN80799Globe Swift LLC · Chino Valley, AZN8079ARegistered aircraftN8079DScheidel Ranches · Pleasant Grove, CAN8079FRegent Aero LLC · Kingsland, GAN8079LHurricane Joaquin LLC · Umatilla, FLN8079TSwannack Peter Jay · Lamont, WAN807KSKansas State University Salina · Salina, KSN80801Hougen Greg H · Rifle, CON80805Elmore Brandon Tracy · Wytheville, VAN80808Bauman Michael F · Olney, ILN8080BNeton Inc · Bradenton, FLN8080THigh Mesa Aviation LLC · Naturita, CON8080XWard B J · Hewitt, NJN80817Early Patricia A · Palmyra, PAN80818Zahler Mitchell J · Stillwater, MNN80819Mccormick Robert A · Scottsdale, AZN8081ACorn Michael Lee · Wilmington, NCN8081LAerowood Aviation LLC · Monroe, NCN8081TSproul Andrew W · Isabella, OKN8082DYork Richard L · Rockport, MAN8082LBurns Jeremiah W · Westerville, OHN8082TStrahm Jennifer · Edgerton, KSN8082XNewman Joseph N · Springfield, MIN80833Irwin International Inc · Corona, CAN80844Laforce Larry B · Big Sandy, TXN80846Bartholomew Don · Gardnerville, NVN8084ARegistration Pending · Madison, NHRegistration pendingN8084FAustin Michael S · Utica, KYN8084SHunter Robert M · Rawlins, WYN8084TKnight Doyle D · Loon Lake, WA
Back to AD 94-05-05 R1