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.

N2421RMerryman Todd K · Shickley, NEBuilt 1969 · S/N 28-5618 N2421SW Grotendiek LLC · Portland, ORBuilt 1979 · S/N 18-7909147 N2421WJohnston John · Sheboygan, WIBuilt 2023 · S/N 2881631 N24228Robinson Raymond E · Nevada, IABuilt 1939 · S/N L-6949 N2422DMckenzie Sandy S · O Brien, FLBuilt 1978 · S/N 38-79A0306 N2422HBell Scott W · Greeley, COS/N 18-7909183 N2422MGuyll Jay D · Denville, NJBuilt 1963 · S/N M-256 N2422PGharazeddine Raja N · Kaplan, LABuilt 1979 · S/N 38-79A0990 N2422YMarker Aviation LLC · Keller, TXBuilt 1966 · S/N 28-3171 N2423Dinstel Daniel A · Alzada, MTBuilt 1960 · S/N 7GCB-55 N24231Wieman Dianne L · Marion, TXFirst renewal noticeBuilt 1939 · S/N L-6979 N24232York Stanley A · Leetonia, OHBuilt 1939 · S/N L6999 N2423EGood Flight Aviation LLC · Stockton, CABuilt 1978 · S/N 17271276 N2423MHarrington Robert D · Chico, CABuilt 2024 · S/N 90611 N2423RAluminum Falcons Flying Club LLC · Bloomsburg, PABuilt 1969 · S/N 28-5619 N24241Kirby Casey J · Oakland, TNBuilt 1979 · S/N 38-79A1104 N24242Fly Sky Ads LLC · Manalapan, NJBuilt 1977 · S/N 15280170 N24244Thomas George P Jr · Woodstock, VTBuilt 1939 · S/N L7119 N24248Wells Sherry A Trustee · Ferndale, MIS/N L-7189 N2424ABarnard Brian · Tallahassee, FLBuilt 1993 · S/N 1809075 N2424DRegistered aircraftS/N 38-79A0307 N2424FPerformance Aviation Services LLC · Belmont, OHBuilt 1964 · S/N 28-2117 N2424VLuvsflying Flight Training LLC · Staten Island, NYBuilt 1972 · S/N 28-7225586 N2425AAtp Aircraft 7 LLC · Wilmington, DEBuilt 2008 · S/N 4496252 N2425MTap Solutions Inc · San Diego, CABuilt 1977 · S/N 28-7816283 N2425NPassano Paige S · Camp Hill, PABuilt 2026 · S/N BD4C033 N24260Aerial Banners Inc · Pembroke Pines, FLBuilt 1977 · S/N 15280180 N24261Citabria Inc · Auburn, CABuilt 1977 · S/N 15280181 N24264Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280183 N24266Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15280185 N24269Sioux Air Inc · South Sioux City, NEBuilt 1977 · S/N 15280186 N2426CSmith Joseph R · Lawrenceburg, INBuilt 1978 · S/N 38-79A0179 N2426FSilcox Charles H · Lakeland, FLBuilt 1979 · S/N 38-79A0435 N2426JLewis Chad · Anchorage, AKBuilt 1979 · S/N 18-7909122 N24270Lafont Jack Christopher · Memphis, TNS/N 38-79A1108 N24276Air Chief Inc · Somerset, PABuilt 1941 · S/N L-7510 N2427DWiplinger Charles · Inver Grove, MNBuilt 1979 · S/N 18-8009007 N2427M18 Rwy LLC · Falmouth, MEBuilt 1977 · S/N 28-7816284 N2427RFalcon Flight Squadron Inc · Los Angeles, CABuilt 1969 · S/N 28-5620 N2427UGalante Anthony R · Saint Clair, MIBuilt 1979 · S/N 28-8090044 N24284Gifford Vernon D · Starkville, MSBuilt 1940 · S/N L-7540 N24286Zech Tyler K · Orlando, FLS/N L-7480 N2428BZahler Mitchell J · Stillwater, MNBuilt 1949 · S/N 3728 N2428DLee Brenda T · Boonville, NYS/N 18-1934 N2428FSmtm Holdings Inc · Wilmington, DEBuilt 1979 · S/N 38-79A0436 N2428KMirzayan Varoojan Y · Fresno, CABuilt 1979 · S/N 38-79A0626 N2428MTyrrell Wesley F · Central, AKBuilt 1947 · S/N 12-1661 N2428PHill Tim E · Russellville, ARBuilt 1970 · S/N 39-64 N24296Cc Aviation Inc · Tracy, CABuilt 1977 · S/N 15280201 N2429JWolf Gary P · Pahrump, NVBuilt 2001 · S/N 5123

Back to AD 90-04-06 R1