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.
N6868FVan Bielert Wouter · Haxtun, CON6868XRegistered aircraftN6869AMccraney John K · Canon, GAN6869XSquires Aaron Lane · Aynor, SCN686BJMayland Ronald W · Cedar Rapids, IAN686TSLee Terence S · Luthersville, GAN6870ELentfer Sheryl A · Anchorage, AKN6871AGibson James G · Harpers Ferry, WVN6872ACoats Alexander · Murrieta, CAN6872FSkybound Aircraft LLC · Blue Point, NYN6873EWallace Joseph R · Winchester, KYN6874AGillum Thomas W III · Davenport, IAN6875EElston Josh · Sterling, AKN6875GStevenson Mark Frank · Anthem, AZN6876EDunn Gary K · Paw Paw, ILN6876FPalmer Dana G · Gatesville, TXN6876GMyers Russell E · Happy Jack, AZN6877ASchenck Alan E · Clarinda, IAN6877EBell Connor C · Maple Valley, WAN6877XSwick Gerald K · Murfreesboro, TNN6878XLinkinhoker Craig W · Carpentersville, ILN6879EWilliams James W · Friendsville, TNN6879XRegistration Pending · Farr West, UTRegistration pendingN687HAnderson Rick L · Valley City, NDN6880EBartel Anthony E Jr · Ridgecrest, CAN6881XWestmoreland Dennis F · Snyder, TXN6882FHernandez Kevin F · Redmond, ORN6883AOswego Joint Venture · Tchula, MSN6883GSchroeder David C · Norfolk, NEN6884Cone Timothy E · Fresno, CAN6885EHeiser Reggie · Polson, MTN6886EHadley David C · Herriman, UTN6887ABradshaw Gary E · Warfordsburg, PAN6887EPatton Martin O · North Ridgeville, OHN6887GMassuet Nancy O · Sunrise, FLN6887HFarrell Drew M · Maryville, MON6888ESteinhausen Darrell · Torrington, WYN6889GKozlowski James · Zeeland, MIN6889XSchler Joseph B · Reno, NVN688DDPropit Inc · Wilmington, DEN688WBaum Eldon L Jr · Wellsville, PAN6891CLeek Roger W · Salem, ORN6891EOakes Stephen · Joshua Tree, CAN6891FN6891f LLC · Woodruff, SCN6892FDent Kelly J · Locust Grove, GAN6892GDetroit Public Schools Community District · Detroit, MIN6893AFarris Lyle E · Faucett, MON6893GHuesgen Paul M · Villa Ridge, MON6894ASw Aero Training LLC · Rio Rancho, NMN6894FSudduth Robert J · Huachuca City, AZ
Back to AD 94-05-05 R1