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.

N164DPAviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 28-8016190 N164DVLankston Robert R · Hernando, MSBuilt 2004 · S/N 90164 N164DZKoehn Don A · Arkdale, WIBuilt 1961 · S/N 28-242 N164ERSilver Express Co DBA · Miami, FLBuilt 1989 · S/N 2841180 N164GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881457 N164JWBarry Edwin R · Apple Valley, CABuilt 2003 · S/N JW001 N164LHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010063 N164LTErickson Steven L · Estherville, IABuilt 1993 · S/N 21633 N164MLJenkins Charles · Franklinton, LABuilt 1998 · S/N 60137 N164MSHose Louise D · Dayton, NVBuilt 1990 · S/N 20004 N164MTTaylor Michael S · Phoenix, AZBuilt 2006 · S/N 25589 N164NNewkirk Thomas R · Garland, NCBuilt 2002 · S/N 25564 N164NATaylor Steven · Des Arc, ARBuilt 1978 · S/N 3878A0403 N164PDKarimi Ashkan · Seattle, WABuilt 2003 · S/N 24705 N164PMChildress Michael W · Laporte, INBuilt 2019 · S/N 60274 N164PSBurton Donald E · Bethesda, MDBuilt 2005 · S/N 3FE030 N164RFFrenzel Robert P · Midlothian, TXBuilt 2010 · S/N 60255 N164RGGlass Roy L · Cardiff By The Sea, CABuilt 2005 · S/N 60266 N164RSCarter David C · Temple, TXBuilt 1995 · S/N 21168 N164RVMytth Spray Solutions Inc · Easley, SCS/N 10164 N164SCCutler Scott D · Olympia, WABuilt 2007 · S/N 23763 N164SPClay David L · Bryceville, FLBuilt 1997 · S/N ML01 N164SWNew England Aviation LLC · Plainville, CTBuilt 1975 · S/N 28-7690077 N164TMMacdowell John E · Kent, WAS/N 23524 N164VGSchwartz David · Tualatin, ORBuilt 1998 · S/N 20438 N164WGBug Smasher LLC · Mitchell, SDBuilt 1990 · S/N 164 N164WMMcclellan Nicklas C · Mims, FLBuilt 2000 · S/N 22423 N164YFTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1957 · S/N 23-1234 N16500Corbin Russell B · North Olmsted, OHBuilt 1936 · S/N 4401 N16509Greensburg Jeannette Airport Administration · Jeannette, PABuilt 1973 · S/N 28-7305271 N1650GWright Jeffrey Crandel · Opelika, ALBuilt 1968 · S/N 128 N1650JQureini Khalil H Vii · Kansas City, MOBuilt 1967 · S/N 28-24043 N1650RKock Berwin M Trustee · Grove, OKBuilt 1975 · S/N AA1B-0550 N16513Ashworth Diane A Executor · Chase City, VABuilt 1973 · S/N 28-7305273 N1651ENoffsinger Robert L · Winston Salem, NCS/N 17271081 N1651HMoore Patrick E · Anchorage, AKBuilt 1990 · S/N 10-5116 N1651PCaron Ty · Redmond, ORBuilt 1954 · S/N 18-3766 N1651RThrasher Rodney L · Bartonsville, PABuilt 1976 · S/N AA1B0651 N16526Wesley Joseph L · Pismo Beach, CABuilt 1973 · S/N 28-7325291 N16527Skolnick Sanford M · Novato, CABuilt 1973 · S/N 28-7305274 N1652GRunway 5 LLC · Wurtsboro, NYBuilt 1968 · S/N 122 N1652PCcf Ventures Inc · Bangor, MEBuilt 1954 · S/N 18-3767 N1652REwing Kneale Daniel · Tulsa, OKBuilt 1976 · S/N AA1B0652 N16530Beldon Concrete LLC · Liberty, KYBuilt 1973 · S/N 28R-7335158 N16531Bethge Wade K · Paxinos, PABuilt 1973 · S/N 28R-7335159 N16534Wahler Edward William III · Asheville, NCBuilt 1973 · S/N 28-7325292 N16535Wdc Enterprises LLC · Beaumont, TXBuilt 1973 · S/N 28-7325293 N16537Lesmeister Dillon J · Chadron, NEBuilt 1973 · S/N 28-7305277 N1653AFarmah Aviation LLC · Cary, NCBuilt 2007 · S/N 14121C N1653JSale Reported · Bloomburg, TXSale reportedBuilt 1967 · S/N 28-24047

Back to AD 90-04-06 R1