AD 94-05-05 R1
Registered aircraft · 26,231
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.
N2864CRegistration Pending · Bloomington, ILRegistration pending, pending cancellationN2864HKarafit James T · Celina, OHN2864LTakle Management LLC · Bethany, OKN2864NFerguson Ernest E · Portland, ORN2864STop Aircraft Leasing LLC · Wilmington, DEN2865LIfr LLC · Springfield, MON2866LRegistration Pending · Spring Branch, TXRegistration pendingN2866VLyles Ed · Newnan, GAN2867CPlatt Ranch Inc · Kim, CON2867NPdb Aviation LLC · Williamson, GAN2867SJarrell Loyd F · Whitesburg, TNN2868CWhiteley David N · Graham, TXN2869KSimpkins Kenneth J · Seymour, INN2869LHelmstetler John D · Mt Vernon, TXN2869NPennell Mark G · Sparta, NCN28701Knight Robert T Sr · Baton Rouge, LAN2870HTrahan John L II · Lebanon, ORN2870NOlson Carl I · North Pole, AKN2870UKline Kevin J · Clyde, OHN2870ZTracy Beverly E · Wray, CON2871USt Clair Dustin W · Cloverdale, CAN2872VRamirez Jose · Altadena, CAN2873CHart John E · West Yellowstone, MTN2873NBeck Dustin R · Millbrook, ALN2874CLarson Ivan · Parker, AZN2874LSchirack John · Decatur, INN2874NPreston Philip L · Tucson, AZN2875LDavenport Ross K · Raleigh, NCN2875NBrooks Ryan M · Sorrento, LAN2875SHolland Van D · Sandy Valley, NVN2875UWalter Karl F · Fayetteville, GAN2876SRay Charlie B · Prosser, WAN2876UPianalto David · Wichita, KSN2877CCarlson John R · Plainfield, WIN2877SWarner David F · Altoona, IAN2877UMelin James · Livingston, MTN28782Nytko Rafal · Elk Grove, ILN2878EHumphrey Daryle C · Graford, TXN2878LHolbrook David A · Toccoa, GAN2879EGriffin Douglas Trustee · Red Bluff, CAN2879HSmith Harry L · Leesburg, FLN287CCLapointe Timothy Mark · Raleigh, NCN2880CBuchert Allen C · Grand Rapids, MNN2880SHigh Exposure Inc · Wilmington, DEN2881CCompton Steven · Anchorage, AKN2881LCore Alan L · Indianola, IAN2881NFugleberg Richard H · Mayville, NDN2881SSerbus Gary E · Olivia, MNN28822Edwards Gordon O · Casper, WYN2882NWhite 120 LLC · Galesburg, KS
Back to AD 94-05-05 R1