Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N6182BPipkin Chester L · Boise, IDBuilt 1957 · S/N 34182 N6182FAllsouth Aviation LLC · Buford, GABuilt 2008 · S/N 18282079 N6182UEfi Aviation LLC · Wilmington, DEBuilt 2008 · S/N 18282080 N6183ECivil Air Patrol Inc · Maxwell Afb, ALBuilt 1983 · S/N 18268351 N6183NLewis A Everett Jr · Chico, CAFirst renewal noticeBuilt 1978 · S/N 21062954 N6183SFarm Air LLC · Gridley, CABuilt 2004 · S/N 18281389 N6184CRegistered aircraftBuilt 1979 · S/N 21063824 N61851C-180 Kbn LLC · East Lyme, CTBuilt 1977 · S/N 18052804 N61854Timm Robert S · Minneapolis, MNBuilt 1977 · S/N 18052805 N6185BGust William J DBA · Monument, COBuilt 1978 · S/N 21062701 N6185FLyford Charles A IV · Bellevue, WABuilt 1977 · S/N 18265984 N6186BConnelly William L · Lovell, MES/N 34186 N61874Erickson Kirk E · Lake Havasu City, AZS/N 18052809 N61877Harrison Jason J · Walla Walla, WABuilt 1977 · S/N 18052810 N6187FNuxoll Builders · Clarkston, WABuilt 1968 · S/N 21059087 N6187JSky King Farmer LLC · Bentleyville, PABuilt 2008 · S/N 18282094 N6187YSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608309 N6188BSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608310 N6188QSilver Creek Aviation Services · Fort Worth, TXBuilt 2008 · S/N 20608305 N6188RPeterson Bruce L · Brighton, COBuilt 1966 · S/N T210-0088 N6188USug-Air LLC · Corpus Christi, TXS/N 21064919 N6188YLexington Enterprises Group Inc · San Jose, CABuilt 1981 · S/N 21064287 N618MKRegistered aircraftBuilt 1978 · S/N 18266388 N618WWood Jim · Seminole, TXBuilt 1966 · S/N P206-0218 N6191BValiair Lc Trustee · Casper, WYS/N 34191 N6192NDolezal Todd R · San Luis Obispo, CABuilt 1978 · S/N 21062963 N6192RAmbrosini Helicopters Inc · Fresno, CABuilt 1966 · S/N T210-0092 N6192UKings Nw LLC · Lakewood, WABuilt 1979 · S/N U20605377 N61938Davis Larry M · Rathdrum, IDBuilt 1977 · S/N 18052814 N6193BSmith Brian R · Avon, CTBuilt 1957 · S/N 34193 N6193CAirspeed Mammography Certifications LLC · Olympia, WABuilt 2008 · S/N 18282072 N6193DDe Anza Building And Maintenance Inc · Los Altos, CAS/N 18281394 N6193FRheinbolt John N · Highmore, SDBuilt 1968 · S/N 21059093 N6193MFreiesleben Thomas K · Brookfield, WIBuilt 2008 · S/N 18282058 N6193RAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 18282061 N61946Straight And Level Aeromedical LLC · Billings, MTBuilt 1977 · S/N 18052815 N6194BMaglaughlin Ronald D · Udall, KSFirst renewal noticeBuilt 1957 · S/N 34194 N6195BBoyd Edward Ayres · Coronado, CABuilt 1978 · S/N 21062705 N6195FRegistered aircraftBuilt 1968 · S/N 21059095 N6196GFirst Air Service LLC · Show Low, AZBuilt 2004 · S/N 18281397 N6196NMccarthy Sean P · Siloam Springs, ARBuilt 1978 · S/N 21062967 N6197BBarber James M · Oklahoma City, OKBuilt 1957 · S/N 34197 N6197ZClermont Management Services Inc · Marietta, GABuilt 2004 · S/N 18281398 N6198BModel A Mlc LLC · Seattle, WABuilt 1957 · S/N 34198 N61999Aircraft Structural Repair Inc · Hamilton, MTBuilt 1977 · S/N 18052819 N6199FAcara Aviation LLC · Portage, MIS/N 21059099 N6199RSchutte Ernest C W · Abita Springs, LAS/N T210-0099 N619CHOrion Works Limited · Denali Park, AKBuilt 1969 · S/N U206-1276 N619WCHansford Mark T · Blue Ridge, GABuilt 2001 · S/N 18280993 N619ZFlying Dentist LLC · Flagstaff, AZBuilt 1972 · S/N 18261176

Back to AD 84-10-01 R1