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.

N233HYTen Mile Ranch Inc · Vale, ORBuilt 2003 · S/N 2233 N233JLMitchell Charles G · Kennewick, WABuilt 1984 · S/N 1301 N233KSJean Buford Randall · Lorena, TXBuilt 1998 · S/N 18280145 N233MMartin Dennis E · Oconto, WIBuilt 1999 · S/N M1 N233MAMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2005 · S/N 40.511 N233RJJohnson Richard Lee · Topeka, KSS/N 233 N233SFSale Reported · Wakarusa, INSale reportedBuilt 1999 · S/N 402-99 N233SHSieger Aviation Services Inc · Bismarck, NDBuilt 1979 · S/N 15283714 N233SPBuchwald Greg W · Grapevine, TXBuilt 1961 · S/N 28-223 N233TCInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N 17257920 N2340DWojtowicz Tomasz · Bronx, NYBuilt 1992 · S/N 2174 N2340LRegistration Pending · San Antonio, TXRegistration pendingBuilt 1962 · S/N M-171 N2340QRegistration Pending · Lewisville, TXRegistration pendingBuilt 1963 · S/N M-411 N2340SWhalen Patrick M · Anchorage, AKBuilt 1979 · S/N 18-7909134 N2340TGrillo Donald · Green Cove Springs, FLBuilt 1971 · S/N 28R-7135228 N23412Performance Sanitation Of Mississippi LLC · Deland, FLBuilt 1995 · S/N 23412 N2341MMarcum Raymond A · Anchorage, AKS/N 12-1604 N2341PJohnson Freddie III · Stafford, VAS/N 38-79A0952 N2341TSky King Aviation LLC · Kearney, MOBuilt 1971 · S/N 28-7225048 N23420Kinnamon Kyle · Eden, MDBuilt 1939 · S/N 3149 N2342AThomas Todd · Sandy Hook, MSBuilt 1952 · S/N 22-732 N2342EWolf John J · Mooresville, NCBuilt 1978 · S/N 17271245 N2342LWilliams James W · Brush Prairie, WABuilt 1963 · S/N M-173 N2342MSteens Mountain Packers · Frenchglen, ORBuilt 1946 · S/N 12-1605 N2342UAdvanced Helicopter Concepts Inc · Frederick, MDFirst renewal noticeBuilt 1992 · S/N 2181 N2343HAerobinninger LLC · Mccall, IDBuilt 1979 · S/N 18-7909173 N2343LBailey Paul W II · Hilton Head, SCBuilt 1963 · S/N M-174 N2343PStalder Fredrick Bleu · Magnolia, TXBuilt 1955 · S/N 22-2754 N2343RSkyhawk Aviation LLC · Rutherfordton, NCBuilt 1969 · S/N 28-5495 N2343TManire Christine D · Ruidoso, NMBuilt 1971 · S/N 28-7225049 N2344AYoung Carl J · Lubbock, TXS/N 22-718 N2344LSpargo Lyle R · Tonopah, AZBuilt 1963 · S/N M-175 N2344MHershey Eric F · Wasilla, AKBuilt 1946 · S/N 12-1485 N2344PVieaux James M · Park Forest, ILBuilt 1955 · S/N 22-2755 N2345LD&S Development LLC · Spring, TXS/N M-177 N2345PSpitzer Helicopter LLC · Woodland Hills, CABuilt 1991 · S/N 1991 N2345QPrunier Phillip M · Kokomo, INBuilt 1963 · S/N M-416 N2345YJackson Shaun K · Tyler, TXBuilt 1967 · S/N 17700145 N2345ZRegistered aircraftBuilt 1977 · S/N 17270190 N2346MHendrickson Gary A DBA · Gold Beach, ORS/N 12-1609 N2346QBurt Marcus D · Pendleton, ORS/N M-425 N2346TBailey Benjamin J · Lincolnton, GABuilt 1971 · S/N 28-7225050 N2346VGauvreau Paul J · Lafayette Hill, PABuilt 1981 · S/N 38-82A0058 N2346ZSoutheast Equipment LLC · Sheridan, WYS/N M-65 N2347QBefumo Joesph M · Manchester, CTS/N M-451 N2347ZZaitsev Saba A · Brooklyn, NYBuilt 1962 · S/N M-59 N2348BHuff Michael W · Fair Grove, MOBuilt 1978 · S/N 38-79A0020 N2348FBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 38-79A0400 N2348JArensmeyer Daniel D · Weybridge, VTBuilt 1963 · S/N M-303 N2348MSurgent Richard L · Wall Township, NJBuilt 1947 · S/N 12-1607

Back to AD 90-04-06 R1