Registered aircraft · 5,102

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

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:81-12-06-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:81-12-06-R1') ORDER BY n_number

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N6171HTyler Cherokee 235 LLC · Lindale, TXBuilt 1977 · S/N 32R-7880047 N6173JMinor Michael W · Summerland Key, FLS/N 32R-7680324 N6173QKinder Mark Edward · Bozeman, MTBuilt 2004 · S/N 18281388 N6174JAloms Enterprises LLC · Marietta, GABuilt 1976 · S/N 32R-7680325 N6179JSanders Jeffrey A · Aurora, COBuilt 1976 · S/N 32R-7680326 N617ECHungerford Brett · Cincinnati, OHBuilt 1975 · S/N 32R-7680096 N617EDMente Charles · Homestead, FLBuilt 1968 · S/N 24-4765 N617ETBunck Richard DBA · Apple Valley, CABuilt 1967 · S/N 32-40205 N6180YChilton Leonard Jay · Caddo Mills, TXS/N 27-3406 N6189YSmith Brian Charles Jr · Lake Mary, FLBuilt 1966 · S/N 27-3415 N618BDSandhu Sky Ventures LLC · Livermore, CABuilt 1989 · S/N 4622047 N618SMHoyle Jason R · Grove, OKBuilt 1975 · S/N 61P-0201-016 N6190JMiller James A · Fairbanks, AKBuilt 1976 · S/N 32R-7680329 N6190UCox Paul G · Bryce, UTBuilt 1974 · S/N 31-7401232 N6193YMatthews Aviation LLC · Hardinsburg, KYBuilt 1966 · S/N 27-3419 N6198JBess Michael S · Niceville, FLBuilt 1976 · S/N 32-7640098 N6199SKilo Tango Aviation LLC · Watford City, NDBuilt 2004 · S/N T18208269 N619CBBeers Aviation LLC · Cedar, MIBuilt 1999 · S/N T2068006 N619WAMckee John D · Dallas, TXBuilt 2004 · S/N T18208339 N61BXAviation Trust Co Trustee · Oklahoma City, OKBuilt 2005 · S/N T18208404 N61FLCobb Glenn A · Blacksburg, VABuilt 1989 · S/N 4622037 N61JWBig Bear Resorts Inc · Big Bear Lake, CABuilt 1979 · S/N 32R-8029023 N61KBPegasus III LLC · Wilmington, DEBuilt 1981 · S/N 31-8152156 N61PLAstar 7 LLC · Middletown, DES/N 61P-0469-186 N61RRAap Holdings LLC · Montana City, MTBuilt 2005 · S/N T20608550 N6200DLundgren Mark C · Philipsburg, MTBuilt 2004 · S/N T18208275 N6201APhenix Transportation LLC · Sheridan, WYBuilt 2004 · S/N T18208281 N6201JL7 Aviation LLC · Geary, OKBuilt 1976 · S/N 32R-7680331 N6205YMarschke Corey A · Stevens Point, WIBuilt 1966 · S/N 27-3432 N620BCBlair Bob Jr · Essex, MOBuilt 1974 · S/N 32-7400037 N620FSBad Attitude Aviation LLC · Peoria, AZBuilt 2000 · S/N 3110A N620HPDepartment Of Public Safety · Norman, OKBuilt 2004 · S/N T20608461 N620RMCbs Inc DBA · Bellefontaine, OHFirst renewal noticeS/N 31-7552040 N620WFSocal Air LLC · Cheyenne, WYBuilt 1967 · S/N 31-17 N620ZJStrategic Investment Counsel Corp · Richardson, TXBuilt 2003 · S/N T18208218 N6210JFhh Air LLC · New Albany, OHS/N 32R-7680333 N6212XCummins Donald · Natchitoches, LABuilt 1963 · S/N 500B-1102-63 N6215XWeber Donald E · Saint David, AZBuilt 1961 · S/N 500B-1056-45 N6219YTab Associates Inc DBA · Port Saint Lucie, FLBuilt 1966 · S/N 27-3446 N621CASair LLC · Natchitoches, LAS/N 4636008 N621DAdams Consulting & Programming Inc · Quincy, ILBuilt 2004 · S/N T18208306 N621RMLouie Garrick S · Reno, NVBuilt 1997 · S/N 3257019 N6221JReese Joel Scott · New Smyrna Beach, FLBuilt 1976 · S/N 32R-7680334 N6224XN6224x LLC · Lake Havasu City, AZBuilt 1961 · S/N 500B-1126-72 N6229JVidosh Brian Jr · Friendswood, TXBuilt 1976 · S/N 32R-7680336 N622AJYonder Corp · Wilmington, DEBuilt 1976 · S/N 31-7612083 N622KCarr Randal J · Chandler, OKBuilt 1975 · S/N 27-7554088 N6230JSonnichsen Landen D · Delta Junction, AKBuilt 1976 · S/N 32R-7680337 N6235YBeaver Douglas G · Harleysville, PAS/N 27-3467 N6238YBarding Steven P · Hogansville, GAS/N 27-3470

Back to AD 81-12-06 R1