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.

N33096United States Air Force Owner · Offutt Afb, NEBuilt 1975 · S/N 28R-7535121 N3309JMomentum Foundation · Tullahoma, TNS/N 15066009 N3309MWillford George A · Waterville, OHBuilt 1947 · S/N 12-2042 N3309ZRubbert Randy C · Reynolds, NDBuilt 1959 · S/N 22-7241 N330ARegistered aircraftBuilt 1954 · S/N 22-1939 N330CPCharlie Pop Flyers Inc · Jacksonville, FLBuilt 1969 · S/N 30-1884 N330CTRobinson Paul J · Saint Joseph, MOBuilt 1974 · S/N 17702158 N330DDUtah State University · Logan, UTBuilt 2002 · S/N 3401 N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209 N330HLSwift David A Trustee · Springfield, MOS/N 24941 N330JBHavens Aviation LLC · Blacklick, OHBuilt 1997 · S/N S1755 N330JHHoover Jerrald J · Yelm, WABuilt 1999 · S/N 1058 N330KRCherry Hill Aviation Inc · Freetown, INBuilt 1956 · S/N 22-4152 N330MEUnique Educational Experiences · Signal Hill, CABuilt 2000 · S/N 172S8462 N330MFWroblewski Peter Ross · Lompoc, CABuilt 2003 · S/N 0033 N330MMHobbs Phillip E · Saint Augustine, FLBuilt 1983 · S/N 444 N330MSCanyon Airmotive LLC · Frisco, TXBuilt 1995 · S/N 750-95 N330RLBlue Mountain Flyers · Palmerton, PABuilt 2002 · S/N 2210 N330TVan Hatten Derek R N · Anchorage, AKS/N 18-2444 N33102Fort Bobby J · O Brien, FLBuilt 1940 · S/N 5819 N33105Rogers William H III · Blackshear, GABuilt 1940 · S/N 5822 N33107Florida Coastal Flying Club LLC · Titusville, FLBuilt 1975 · S/N 28-7525154 N3310AKonrad Robert M · Centennial, COS/N 22-1587 N3310BHilgendorf Ross E · Welcome, MNBuilt 1954 · S/N 22-2125 N3310MToepper Richard B · Port Ludlow, WABuilt 1947 · S/N 12-2041 N3310PLopes Gaston A · Dallas, TXBuilt 1973 · S/N 28R-7435121 N33110Grandview Aviation LLC · Bethel Park, PAS/N 28R-7535122 N3311ARitchie John A Jr · Gold Hill, NCBuilt 1953 · S/N 22-1586 N3311BJackson Tal H · Spearman, TXBuilt 1954 · S/N 22-2126 N3311KBartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 1304 N3311MAdams David R · Concrete, WABuilt 1947 · S/N 12-2170 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N33121Civil Air Patrol Flying Association Inc · Branford, CTBuilt 1975 · S/N 28-7505124 N33123Maccorkle Leon · Round Pond, MEBuilt 1975 · S/N 28R-7535123 N33128Flora Airport Authority · Flora, ILBuilt 1975 · S/N 28-7505125 N33129Cloud 9 Flying Club Inc · Cedar Rapids, IABuilt 1975 · S/N 28R-7535124 N3312ARegistration Pending · Myerstown, PARegistration pendingBuilt 1953 · S/N 22-1584 N3312MDiedrich Paul E · Fort Mill, SCBuilt 1947 · S/N 12-2167 N33138Ables John M · Tehachapi, CABuilt 1975 · S/N 28-7525161 N33139Hallert Benjamin F · Springfield, ORBuilt 1975 · S/N 28-7515320 N3313BOlling Stanley J Trustee · Wanatah, INBuilt 1954 · S/N 22-2128 N33142Cogan Christopher · Warner Robins, GABuilt 1975 · S/N 28R-7535126 N33147Johann Austin J · Richland Center, WIS/N 28-7525163 N33148Hitchcock Lonnie G · Sparta, TNBuilt 1975 · S/N 28-7515322 N33149Great Lakes Air Ventures LLC · Mason, MIBuilt 1975 · S/N 28-7515323 N3314AMichalek Construction Inc · Keosauqua, IABuilt 1953 · S/N 22-1589 N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500 N33150Iowa County Flying Club Inc · Mineral Point, WIBuilt 1975 · S/N 28-7505127 N33151Thayer Victoria · Ontario, CABuilt 1975 · S/N 28R-7535127 N33158Mc Aviation LLC · Paducah, KYBuilt 1975 · S/N 28-7525164

Back to AD 90-04-06 R1