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.
N9865DBha Leasing Inc · Standish, MEN9865JNine Winds Inc · Wilmington, DEN98679Hinaman Arthur W · Locust Grove, GAN9867TClock Kenneth C · Milan, MIN98680Fischer Alfred M DBA · Genoa City, WIN98689Aircraft Guaranty Corp Trustee · Oklahoma City, OKN9868BRobbins Patrick D · Yakutat, AKN98699New James Albert Jr · Seffner, FLN9869TGoff Joseph L · Kingsland, TXN9869YThompson Curtis W · Battleview, NDN9870BAspenglow LLC · Talkeetna, AKN98724Obrien William D · Duluth, MNN98729Aviation Consultants Inc · Newton, NJN9872BSchuler Joyce L · Dutton, MTFirst renewal noticeN9872TSpiker Zachary T · Altoona, ALN98735Burick John C · Juneau, AKN98737Engelskirger Karl D · Valley City, OHN9873JRichards Bradley R · Lake Oswego, ORN9874TVichy Springs Resort Inc · Ukiah, CAN9875JShaw Aviation LLC · Solomon, KSN98765Sauer Roger A · Glenburn, NDN9876BGreenough Dale · Lusk, WYN98775Gabel Jayme L · Jackson, NEN9877TMarks Ivan A · Newbury Park, CAN98781Sullivan Thomas G · Duluth, MNN9878BRittberger Beef Inc · Hermosa, SDN98790Grantonic Paul · Wintersville, OHN98794Seven Tails LLC · Wilmington, DEN9879BStrine Russell A · Reading, PAN9879JMccormack Robert · Sacramento, CAN987CTDiamond Aircraft Sales Of Kentucky LLC · Henderson, KYN98801Gregg Delvin K · Durango, CON98806Williams Michael W · Olathe, KSN9880TCarr Michael J · Murfreesboro, TNFirst renewal noticeN9881Conaway Byron Richard · Savannah, TNN98813Heath Nancy A · Argyle, TXN9882JS&L Aviation LLC · Ashland, OHN98838Miller Michael D · Goffstown, NHN9883BDeal Brady Edward · Anchorage, AKN9883DGalyean Terry L · Kenai, AKN9884BRegistration Pending · Jackson, OHRegistration pending, pending cancellationN9884JDubberly David E · St Simons Island, GAN9885BHill Nelson · Laurel, MSN98862Nowak Nathan R · La Porte, INN98863Statley Logan H · Jamul, CAN98877Akana Bette J · Montague, CAN98880Johnson Jason D · Okahumpka, FLN98883Everett Kerry M · Huntsville, ALN98889Carney Edward R Jr · Germantown, TNN988WZSiegrist Jeffrey M · Harrison, OH
Back to AD 94-05-05 R1