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.

N15LFNorthrup George William · Ellicottville, NYBuilt 1998 · S/N 1395 N15LMKleinert Keith · Alto, GABuilt 1977 · S/N AA1C0116 N15LRBoggs James A · Tucson, AZBuilt 1994 · S/N 1309 N15LWIsaak Robert J · Pocatello, IDBuilt 2001 · S/N 90016 N15LZZambrano Mario · Austin, TXBuilt 1945 · S/N 755460 N15MTTeixeira Matthew R · Clovis, CAS/N 1023 N15NBMorris Russell K · Cameron Park, CABuilt 1978 · S/N AA5B0974 N15NFRegistered aircraftBuilt 1969 · S/N 17258204 N15NGAviat Aircraft Inc · Afton, WYBuilt 2013 · S/N 3189 N15NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 172RG0115 N15PCollins Jeffery S · Griffin, GABuilt 1956 · S/N DH-92 N15PCCarr Patrick L · Fairmont, WVBuilt 1997 · S/N 1214 N15PHBindon Phil E · Wasilla, AKFirst renewal noticeBuilt 1958 · S/N RLH-20 N15PJBreedlove Ernest Dale · Valley Mills, TXBuilt 1999 · S/N 23313 N15QAQuiet Aero LLC · Fort Myers, FLBuilt 1960 · S/N 24-2388 N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568 N15RMFlying Y Farms LLC · Klamath Falls, ORBuilt 1969 · S/N 18-8814 N15RVCrawford Larry G · California, MOS/N 298 N15SEWilliams Paul E · Kendallville, INBuilt 2005 · S/N 1386-2005 N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875 N15TPSmith Richard R · Austin, TXBuilt 2006 · S/N 1990 N15TSSchell Timothy N · Dubois, WYBuilt 1996 · S/N 23802 N15TYArneson Kenneth W · Beaverton, ORBuilt 1975 · S/N 150-76713 N15USale Reported · Van Nuys, CASale reportedBuilt 1979 · S/N ME-160 N15VRCarley Daniel · Center Moriches, NYBuilt 1998 · S/N 21486 N15WJFleming Laurence Erik · Salinas, CABuilt 1999 · S/N 824-99 N15WVWhiskey Victor Aviation LLC · Fairmont, WVBuilt 1969 · S/N 667 N15XXDalks Leasing Inc · Wilmington, DEBuilt 1951 · S/N 18-811 N15YMMiller Jeff A · Deering, NHBuilt 1996 · S/N 168 N1600GBrown David · Bell Buckle, TNBuilt 1959 · S/N DH-211 N1600RColeman Daniel L · Chattanooga, TNBuilt 1974 · S/N AA5-0700 N1601Moretti Warren R · Petaluma, CABuilt 2004 · S/N 20588 N16019Brown Kenneth D · Port Murray, NJS/N 17702478 N1601SRussell Bryan E · Joshua, TXS/N 28-7790057 N16021Hill Allen W · La Junta, COBuilt 1976 · S/N 17702479 N16023Carr Richard D Trustee · Stockton, MOBuilt 1976 · S/N 17702480 N1602ABent James L Jr DBA · Palatine Bridge, NYS/N 18-1240 N1602BBoyd Aaron · S San Fran, CABuilt 1979 · S/N 17272737 N1602GHenry Thomas J · Ellicott City, MDBuilt 1968 · S/N 613 N1602PDavis Jacob J · Georgetown, TXBuilt 1954 · S/N 22-2417 N1602VRegistration Pending · Lucas, TXRegistration pendingBuilt 1974 · S/N 17263690 N1603EWright Michael A · Advance, NCBuilt 1978 · S/N 17271062 N1603GCp Aviation Inc · Santa Paula, CABuilt 1968 · S/N 609 N1604AFredericks Elmo J · Mandaree, NDBuilt 1951 · S/N 18-1242 N1604GMut Henry · Brookshire, TXBuilt 1968 · S/N 101 N1605GAllen Matthew C · Pomona, CABuilt 1968 · S/N 99 N1605RGeiger Emory H Jr · Snellville, GABuilt 1976 · S/N AA1B-0605 N16066Thompson Derek D Jr · Dunkirk, MDBuilt 1976 · S/N 17702482 N1606AFilkill David B · Willow, AKBuilt 1951 · S/N 18-1246 N1606GNigri David A · Smithfield, RIBuilt 1968 · S/N 112

Back to AD 90-04-06 R1