Skip to content

Registered aircraft · 81,720

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

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 N164SAOlson Helicopters LLC · Corpus Christi, TXBuilt 2006 · S/N 1559 N164SCCutler Scott D · Olympia, WABuilt 2007 · S/N 23763 N164SJFriedman Matthew · Herndon, VABuilt 1997 · S/N 18280064 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 N164ULariviere Jeffrey A · Douglassville, PABuilt 1967 · S/N 32-996 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 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 N16518Dokter Garret H Jr Trustee · Big Bear Lake, CABuilt 1973 · S/N 28-7310102 N1651CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11755 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 N1653PAirmotive Service LLC · Brigham City, UTBuilt 1954 · S/N 18-3768 N16547Mickle Charles R · Hinton, OKS/N 28-7325297 N16548Watchman Aviation LLC · Pierceton, INBuilt 1973 · S/N 28-7305280 N1654GGelvin Stanley M · Central, AKBuilt 1968 · S/N 123 N1654JStygar Richard M · Coal City, ILBuilt 1967 · S/N 28-24049 N16551Mike Smith Construction Inc · Holyoke, COBuilt 1973 · S/N 28-7305283 N16554Sk Group LLC · Moore, SCBuilt 1973 · S/N 28R-7335162 N16555Vampola Timothy D · Bellevue, NEBuilt 1973 · S/N 28R-7335163 N16556Sale Reported · Fargo, NDSale reported, pending cancellationBuilt 1973 · S/N 28-7310105 N1655AConnell Romeao J · Gresham, ORS/N 22-419 N1655JGallant Arthur · Kingston, NHBuilt 1967 · S/N 28-24051 N16560Wasson Tom L · Lakeport, CABuilt 1973 · S/N 28-7325298

Back to AD 81-18-04 R2