Registered aircraft · 68,369

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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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:90-04-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.

N1882PAir Dakota Flite Inc · Hettinger, NDBuilt 1955 · S/N 18-4163 N1882TSonel Derya · Colorado Springs, COS/N 28-7225037 N1883Nielsen Jeff S · Ashland, ORBuilt 1996 · S/N 20060 N1883JAnderson Dan Melvin · Salina, UTBuilt 1968 · S/N 28-24327 N1883PDavis Tom C · Belle Fourche, SDBuilt 1955 · S/N 18-4164 N1883QMitchell Philip J · Arlington, TXS/N 177RG0283 N1883TWilkins Joseph K · O Fallon, MOBuilt 1971 · S/N 28-7225038 N18841Quality Aviation Inc · Atlanta, GABuilt 1977 · S/N MC-509 N1884PStoica Michael J Jr · East Liverpool, OHBuilt 1955 · S/N 18-4165 N1884VMurphy Edward L · Fairmont, WVBuilt 1974 · S/N 17263781 N18858Martindale Ian C · Seattle, WABuilt 1977 · S/N MC-510 N18859Molnair LLC · Columbus, GABuilt 1977 · S/N MC-511 N1885GGoodfriend Neal · Sanger, TXS/N 144 N1885JGem Aviation Corp · Sugar Land, TXBuilt 1968 · S/N 28-24329 N1885QHansen Peter J · New Iberia, LABuilt 1972 · S/N 177RG0285 N18861Phillips Gary O · San Rafael, CABuilt 1977 · S/N M-1953 N18862Koenig Michael · Mooresville, NCBuilt 1977 · S/N M-1956 N18863Esch Joseph W Executor · Carson, WAS/N K-129 N18864Burnett Robert J · Garden Valley, CABuilt 1977 · S/N M-1955 N18865Shoreline Aviation LLC · Norman, OKBuilt 1977 · S/N MC-514 N18867Wisniewski Joseph B · Ormond Beach, FLBuilt 1977 · S/N M-1954 N18869Griggs Gerald Warren · Goddard, KSBuilt 1937 · S/N K-154 N1886AGriffith Richard B · Sycamore, ILBuilt 1952 · S/N 18-1719 N1886JJones Freddy D · Amsterdam, OHBuilt 1968 · S/N 28-24330 N1886PAlligood Allen K · Wasilla, AKBuilt 1955 · S/N 18-4169 N1886TKoester Deborah J · Courtland, MNBuilt 1971 · S/N 28-7225020 N1886VAngelone Inc · Elkhart, INBuilt 1974 · S/N 17263782 N18874Registration Pending · Pantego, NCRegistration pendingBuilt 1977 · S/N MC-518 N1887AErickson Paul F · Wasilla, AKS/N 18-1725 N1887GJewett Cody C · Isabel, SDBuilt 1968 · S/N 117 N1887QLosyad LLC · Sanford, FLBuilt 1972 · S/N 177RG0287 N1887TCulver Investments LLC · Gordon, TXBuilt 1971 · S/N 28-7225033 N18887Clifford Royce Ellen · Leucadia, CABuilt 1977 · S/N MC-519 N18888Symosko Stephen · Oakdale, PABuilt 1977 · S/N MB-858 N1888AAlaska Tailwheel LLC · Fairbanks, AKBuilt 1952 · S/N 18-1718 N1888QAmerican Aerial Photos LLC · Efland, NCBuilt 1972 · S/N 177RG0288 N18895Jmetic Consulting LLC · Springs, TXBuilt 1977 · S/N M-1963 N1889GRainbow Flying Service LLC · Moses Lake, WABuilt 1968 · S/N 93 N1889HPlotnick Daniel G · Foxborough, MABuilt 1977 · S/N 28-7725166 N1889JBrain James E Jr · Rogers, ARBuilt 1968 · S/N 28-24334 N1889MBovington Samuel R · Stanwood, WABuilt 2017 · S/N 83309 N1889PVeatch William E · Hood River, ORBuilt 1955 · S/N 18-4175 N1889QRuff Randall N · Bay City, MIBuilt 1972 · S/N 177RG0289 N1889VCroome James Earl Jr · Sandersville, GABuilt 1974 · S/N 17263783 N188AKSmith David E · Monmouth, ORBuilt 2025 · S/N 0099 N188BCWaldron Elijah L · Murfreesboro, TNBuilt 2019 · S/N 598-2019 N188BGGildersleeve Jud M · Hastings, MIBuilt 1988 · S/N 1032 N188BSSmith Brenda S · Livingston, TXBuilt 1977 · S/N MB-873 N188DHDunworth Jack R · Rutledge, GABuilt 1968 · S/N 680119 N188DSCopper River Airmotive LLC · Copper Center, AKBuilt 2005 · S/N 2326

Back to AD 90-04-06 R1