Registered aircraft · 68,375

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.

N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860 N2860TSchmitz Nicholas S · East Lyme, CTBuilt 1972 · S/N 28-7205232 N2860ZCarter Harold · Elizabethton, TNBuilt 1959 · S/N 22-6857 N28610Brown Ryan O · Columbia, TNBuilt 1977 · S/N AA5B0677 N28614Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843731 N28618Morgan Robert J · Mojave, CABuilt 1978 · S/N AA5B0707 N2861BScotts Helicopter Service Inc · Le Sueur, MNBuilt 1958 · S/N 1436 N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861 N2861TDesert Sky Flight Group Inc · Tucson, AZBuilt 1972 · S/N 28R-7235147 N28622Cole Quentin P · Huntingdon Valley, PABuilt 1978 · S/N AA5B0708 N28627Key City Fliers Inc · Maquoketa, IAS/N 28-7990420 N2862APrecious Heir Holding Company LLC · Tucson, AZBuilt 1979 · S/N 28-7916486 N2862MFrederick David · Juneau, AKBuilt 1946 · S/N 12-1285 N2862PTexas Amphibians LLC · Braunfels, TXBuilt 1978 · S/N 929 N2862TReed Thomas F · Maize, KSS/N 28R-7235148 N2862XMathews Nancy M · Englewood, TNS/N 17700262 N28630Flying Tiger LLC · Chesapeake, VABuilt 1978 · S/N AA5B0711 N28631Perry Colin C · Petaluma, CABuilt 1978 · S/N AA5B0712 N28633Fritz William J · Carnesville, GABuilt 1978 · S/N AA5B0713 N28634Wolvin Michael S · N Fort Myers, FLBuilt 1978 · S/N AA5B0714 N28635N28635 LLC · Harding, PABuilt 1978 · S/N AA5B0715 N28637Rust Scott Allen · Indianapolis, INBuilt 1978 · S/N AA5B0716 N28639International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N AA5B0718 N2863EWetherley Aviation LLC · Boise, IDBuilt 1978 · S/N 17271352 N2863MBaillie Ryan B · Hermitage, TNBuilt 1977 · S/N 28-7816318 N2863PGic Inc · Oneill, NEBuilt 1979 · S/N 28-7990504 N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863 N2863UEady Paul Clifford · Lakeside, CABuilt 1979 · S/N 28-7990505 N2863VBfree2fly LLC · Delaware, OHBuilt 1979 · S/N 28-7990506 N2863ZWhitaker Eric L · Detroit, TXS/N 22-6862 N28641Cpr Pacific LLC · Salinas, CABuilt 1978 · S/N AA5B0719 N28646Kutok Stephen M · Commack, NYBuilt 1978 · S/N AA5B0721 N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864 N2864WSpearhead Ranch LLC · Douglas, WYBuilt 1987 · S/N 1001 N2864XCardinal Airways LLC · St Johns, FLBuilt 1967 · S/N 17700264 N2864ZUecker Todd M · Port Townsend, WABuilt 1959 · S/N 22-6871 N28650Loseka Tiger LLC · Columbia, ILBuilt 1978 · S/N AA5B0723 N28651Dass Aaron · Conroe, TXBuilt 1978 · S/N AA5B0724 N28655Straight & Level Aviation LLC · Bradenton, FLBuilt 1978 · S/N AA5B0731 N28657Gutelius Kenneth · Lake Orion, MIBuilt 1978 · S/N AA5B0733 N28658Hadden Aviation LLC · Sylacauga, ALBuilt 1978 · S/N AA5B0734 N28659Timidaiski Daniel · Mikilteo, WABuilt 1978 · S/N AA5B0735 N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865 N2865RCarmel Aviation Inc · Boise, IDBuilt 1969 · S/N 28R-35308 N2865ZCrouder Trevor J · Fairbanks, AKBuilt 1959 · S/N 22-6864 N28663Ramsey Kelly · Argyle, TXBuilt 1978 · S/N AA5B0737 N28664Aces Flying Services LLC · Sanford, NCBuilt 1978 · S/N AA5B0738 N28667Rehberg Eric · Chattanooga, TNBuilt 1979 · S/N 28-7990422 N2866BBulger Edward P · Newburyport, MAS/N 1002 N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866

Back to AD 90-04-06 R1