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.
N98169Honcho Air LLC · Portage Des Sioux, MON9816MShaw David H · Nenana, AKN9816YJones Stephen C · Wadsworth, ILN98178Davis Bret Reed · Boynton Beach, FLN9817JDonahue Patrick J · Carriere, MSN9817YMurray Luke C · Gregory, SDN98180Moss Frank V · Punta Gorda, FLN9819JFranco Louise A · El Cerrito, CAN9820JBenair LLC · Bonita Springs, FLN9820TSamson Robert C · Waterford, WIN98216Komara Aaron · Fayetteville, TNN9822JSiskiyou Pacific Inc · Central Point, ORN9823YCentral Air Parts Inc · Staunton, ILN98246P & E Investments LLC · Coconut Creek, FLN9824TNeufeld Dwayne A · Coeur D Alene, IDN9824YSanzaro Aero LLC · Bunnell, FLN9825TLong Duane C · Baskin, LAN9828JIcarus Copters LLC · Lancaster, CAN9828TArts Donald W · Lincoln, CAN9829TGeske Kenneth A · Thief River Falls, MNN982HEHuddleston Edward A · Oaktown, INN98300Bell Patrick C · Novato, CAN9830JJohnsen Christian · Big Bear Lake, CAN9830TPoe Joshua J · Peculiar, MON98310Hughes Brian J · Renton, WAN98311Reeves Todd J · Mosier, ORN98318Schedel John R · Hernando, FLN9831JHaddix Stanley D · Hagerhill, KYN9831MPham Hieu T · Steilacoom, WAN9832JWolfe William Keith · Greenbrier, ARN98340Das Air Inc · Wilmington, DEN98347Benoit Robert W · Hot Springs, ARN9834THulbert Douglas S · Santa Maria, CAN98353Yellow Therapy LLC · Kalispell, MTN9835JCrooks Curtis L · Truckee, CAN9835TVfr Ltd · Wilmington, DEN9836YHaughee Jared · Warsaw, INN9837TSmith Robert M III · Taft, CAN9838EErickson Lambert A · Littlefork, MNN9838MWaldor Asherjohn · Ford City, PAN98397Clark Thomas M · Fiskdale, MAN98399Francis James E · King City, CAN9839JDarling Dudley W · Northborough, MAN9839YHayton James B · Sedro Woolley, WAN983AMPivitech LLC · Gravette, ARN98400Cross Thomas Ad · Yacolt, WAN98405Wade Danley · Willows, CAN9840JBean James P · Tulsa, OKN9840YBrown Michael D · Columbia, TNN98413Lutes Richard L · Hampshire, IL
Back to AD 94-05-05 R1