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.

N97958Plate Jack R · Clarklake, MIBuilt 1979 · S/N 18267255 N97961Rutter Matthew J · Great Falls, MTBuilt 1979 · S/N 18267256 N97963Nichols Timothy · Poulsbo, WAS/N 18267257 N97968Moses Fredric P · Wayland, MABuilt 1979 · S/N 18267258 N9796XHulett George A · Woodland Hills, CABuilt 1962 · S/N 21058096 N97970Mcveigh Scott M · Westlake Village, CABuilt 1979 · S/N 18267259 N97971Gregory Scott L · Prescott, AZBuilt 1979 · S/N 18267260 N97975Winga Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1979 · S/N 18267262 N9797GPowers Burton L · Anchorage, AKS/N 18052297 N9797XDeckpro LLC · Rexburg, IDBuilt 1962 · S/N 21058097 N97981Grindstaff Aircraft Leasing Inc · Crossville, TNBuilt 1979 · S/N 18267266 N9798GJantz Merle Trustee · North Pole, AKBuilt 1972 · S/N 18052298 N9798ZWright Air Service Inc · Fairbanks, AKBuilt 1982 · S/N U20606665 N97993N97993 LLC · Middleton, MABuilt 1979 · S/N 18267272 N97995Lxs Farms LLC · El Paso, TXBuilt 1979 · S/N 18267273 N97997Redline Aviation Inc · Sioux City, IABuilt 1979 · S/N 18267275 N9799ESkyhigh Trade LLC · Wilmington, DEBuilt 1984 · S/N 18268447 N9799HFriehe Berend · Moses Lake, WABuilt 1981 · S/N 18268033 N97AVCertified Aviation LLC · Dawson, GAS/N 18266809 N97EKern County Sheriffs Department · Bakersfield, CABuilt 1983 · S/N 21064788 N97FCParker Cullen B · San Antonio, TXBuilt 1962 · S/N 18051106 N97HYFulghum Michael Eugene · Humble, TXBuilt 2004 · S/N 18281349 N97RWWiplinger Robert D · Inver Grove Hts, MNS/N 18280387 N9800AB T Aircraft Restorations · Bellevue, WABuilt 1950 · S/N 7557 N9801ASpivey Kenneth R Jr · Vestavia, ALBuilt 1950 · S/N 7480 N9802EPouya Hamid · San Jose, CABuilt 1975 · S/N 18263916 N9802HPatterson Aubrey III · Saltillo, MSBuilt 1981 · S/N 18268034 N9802XMeise Fred W · Moses Lake, WABuilt 1961 · S/N 1850002 N9802ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U206-06667 N9803HCoburn Alan B · Plantation, FLBuilt 1981 · S/N 18268035 N9803VKoinzan Enterprises Inc · Elgin, NEBuilt 1966 · S/N 188-0053 N9803XPatrick Samuel Garrett · Durango, COBuilt 1961 · S/N 1850003 N9803ZBig Horn Aviation Group · Fort Worth, TXBuilt 1982 · S/N U20606668 N9805AMay Richard U · Soquel, CABuilt 1950 · S/N 7484 N9806EMccullough John D · Maize, KSBuilt 1985 · S/N 18268448 N9806XWelliver Charles Kimmel Jr · Staunton, VABuilt 1961 · S/N 185-0006 N9807HMid Eastern Specialties Ltd · Wilmington, DEBuilt 1981 · S/N 18268037 N9808HThiel Av LLC · Lewistown, MTBuilt 1981 · S/N 18268038 N9808XKeller Matthew Charles · Wasilla, AKBuilt 1961 · S/N 185-0008 N9809HHumphries Steve J · Raleigh, NCBuilt 1981 · S/N 18268039 N980HPTopher Enterprises LLC · Bucyrus, KSBuilt 1978 · S/N R18200205 N980JKKoskan John M · Wood, SDBuilt 1980 · S/N R18201591 N980LKmq Data Acquisitions LLC · Chugiak, AKBuilt 1973 · S/N 18262273 N980SCSky Horse LLC · Santa Cruz, CABuilt 1982 · S/N 21064774 N9810ACarroll Judy Diane · Naples, FLBuilt 1950 · S/N 7489 N9810HLoos Gregory S · Boscobel, WIBuilt 1981 · S/N 18268040 N9811HArnaud Eldon · Fort Lauderdale, FLBuilt 1960 · S/N 21057667 N9811ZBlack Hawk Brothers LLC · Lakeland, FLBuilt 1982 · S/N U20606674 N9812XSmith James M · Fitchburg, WIBuilt 1961 · S/N 1850012 N9813ER&L Enterprise Group LLC · Wilmington, DEBuilt 1975 · S/N 18263919

Back to AD 84-10-01 R1