Registered aircraft · 68,377

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.

N3936MAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816386 N3936PTroyer Robert E · Toledo, WABuilt 1956 · S/N 22-3611 N3936TGreen Castle Aero Club Ltd · Oxford, IABuilt 1967 · S/N 28R-30277 N3937MDowns Douglas · Fairbanks, AKS/N 12-2825 N3937ZBundy Jerrian M · Anchorage, AKBuilt 1962 · S/N 18-7783 N39387Registration Pending · Post Falls, IDRegistration pendingBuilt 1972 · S/N 536 N3938CHale Phil · Palm Bay, FLBuilt 2008 · S/N 70569 N3938KCdb Group Holdings LLC · Sheridan, WYBuilt 1967 · S/N 28-23813 N3938NSundance Aviation Inc · Richland, WABuilt 1968 · S/N 680065 N3938PSwoboda Matthias W · Green Bay, WIBuilt 1956 · S/N 22-3613 N3938QGreen Carl P · Columbia, MSBuilt 1971 · S/N 17260038 N3938ZCooper Donald A · Casper, WYBuilt 1962 · S/N 18-7784 N3939KRegistration Pending · Grand Prairie, TXRegistration pendingBuilt 1967 · S/N 28-23814 N3939MMclaughlin Scott A · Defiance, IABuilt 1947 · S/N 12-2591 N3939RReid Edwin G Jr · Hollywood, MDBuilt 1970 · S/N 28-5850 N3939TDespins David R · Gray, MES/N 28R-30281 N3939XArapahoe Flight Club LLC · Colorado Springs, COBuilt 1975 · S/N 28-7515434 N3939ZCarnine Daniel · Angora, NEBuilt 1962 · S/N 18-7785 N393ACollins Elizabeth M · Carnelian Bay, CABuilt 1949 · S/N 54 N393AWRoe Elton L · Harrison, ARBuilt 1968 · S/N 252 N393DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843851 N393GTHuskair LLC · Chesterfield, MOBuilt 2010 · S/N 3093 N393HWilliams Fred V · Reno, NVBuilt 2022 · S/N 58P-111P/112P-P299 N393LSBourne George L · Universal City, TXBuilt 2003 · S/N 81405 N393MAVandelay America LLC · Newport Beach, CABuilt 2007 · S/N 514-2007 N393RCBarnes Thomas M · Pittsboro, NCBuilt 2001 · S/N 1176 N393RVBell Paul E · Granbury, TXBuilt 2023 · S/N 92293 N393TBTom Brown Consulting LLC · Ave Maria, FLBuilt 1969 · S/N 30-1874 N393TCAnderson Kelvin W · Denver, COBuilt 2001 · S/N 1393 N393TFGibsons Gas Inc · Holland, NYS/N 3 N393THDobesh Craig L · Granbury, TXS/N 8 N393TMAvion Acrobatico LLC · Waterloo, ILBuilt 1973 · S/N 82-73 N3940KAir Ventures Flying School LLC · Smithfield, RIBuilt 1967 · S/N 28-23764 N3940MCondair Flyers Inc · Latham, NYBuilt 1978 · S/N 28-7816388 N3940QN3940q LLC · Newnan, GABuilt 1971 · S/N 17260040 N3940ZGrasser Edward K · Palmer, AKBuilt 1963 · S/N 18-7786 N3941KHawkins Allan S · Lizella, GABuilt 1967 · S/N 28-23816 N3941MHilterbrand Drew S · Ninilchik, AKBuilt 1947 · S/N 12-2832 N3942MKraft Duane J · Timber Lake, SDBuilt 1947 · S/N 12-2593 N3942NFlying Services Inc · Wilmington, DEBuilt 1968 · S/N 680007 N3942QSullivan Donald Edward II · Edwards, ILBuilt 1971 · S/N 17260042 N3942TAuburn Valley LLC · Farmington, MNBuilt 1967 · S/N 28R-30285 N3943Nighthawk N8231g LLC · Pompano Beach, FLBuilt 1984 · S/N 17276186 N3943XSuberg Valerie G · Windsor, CABuilt 1975 · S/N 28R-7535362 N3944FHenley Johnny · Trenton, NCBuilt 1976 · S/N 28-7615432 N3944KPeiker Laramie · Revillo, SDBuilt 1967 · S/N 28-23819 N3944MHebert Troxell S · Delta Jct, AKBuilt 1947 · S/N 12-2834 N3944QFeauto Aviation Inc · Saint Cloud, FLBuilt 1971 · S/N 17260044 N3944SAlpha Romeo LLC · Wray, COBuilt 1990 · S/N 728 N3944XClark Nicholas J · Wilmington, DEBuilt 1975 · S/N 28R-7535363

Back to AD 90-04-06 R1