Skip to content

Registered aircraft · 40,472

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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N16446Cash Management Consulting LLC · Granite Springs, NYBuilt 1973 · S/N 28-7325274 N16447Cornejo Mauro R · Tucson, AZBuilt 1973 · S/N 28-7325276 N16448Lynch Timothy Christopher · Robbinsville, NJBuilt 1973 · S/N 28-7305256 N16449Cloud Nine Flying Club Inc · Fergus Falls, MNBuilt 1973 · S/N 28-7305257 N1644EMountain Flyers Inc · Hendersonville, NCBuilt 1979 · S/N 17271079 N1644JTurner Colby · Lamar, COBuilt 1967 · S/N 28-24036 N16456Blackwell Jerry R · Jackson, TNBuilt 1973 · S/N 28-7305260 N1645BIko Aero Services LLC · Natchez, MSBuilt 2003 · S/N 5116 N1645GNashua Aerial Advertising LLC · Nashua, NHBuilt 1968 · S/N 63 N1645JWhite Jesse J · Penn Valley, CABuilt 1967 · S/N 28-24037 N16468Am Aviation LLC · University City, MOBuilt 1973 · S/N 28-7325279 N1646GUndem John D · Grand Rapids, MNBuilt 1968 · S/N 100 N1646PGerigs Trucking And Leasing Inc · Hoagland, INBuilt 1954 · S/N 22-2462 N16484Johnson Training Institute LLC · Zachary, LABuilt 1973 · S/N 28-7305264 N16485Elemental Process Solutions LLC · Troy, ILBuilt 1973 · S/N 28-7305265 N16488Kuemmerle Steven C · Grayslake, ILBuilt 1973 · S/N 28-7305266 N16490Schlott James W · East Falmount, MABuilt 1973 · S/N 28-7325284 N16492Fields Franc C · Jessup, MDBuilt 1973 · S/N 28-7305268 N16496Gesler Mark A DBA · Lima, OHBuilt 1973 · S/N 28-7305270 N1649BBurke Cary C · Lake Stevens, WAS/N 22-2037 N1649GBentley Kyle S · Keene, NHBuilt 1968 · S/N 120 N1649JRegistration Pending · Bozeman, MTRegistration pendingBuilt 1967 · S/N 28-24042 N1649PSutton Aircraft Salvage LLC · Palmer, AKFirst renewal noticeBuilt 1954 · S/N 22-2465 N164BFFloyd Joseph B · Bowling Green, KYBuilt 2005 · S/N 24368 N164BGVanhuben Daniel James · Rochester, NYS/N 164 N164BNHoffman William R · Canby, ORS/N 60050 N164BWLoeppky Neal W · Seminole, TXBuilt 1994 · S/N 4R1 N164CBBrooks Chris A · Port Orange, FLBuilt 2004 · S/N 22935 N164DFStraighten Up Fly Right LLC · Oklahoma City, OKBuilt 1999 · S/N 24606 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 N164LTErickson Steven L · Estherville, IABuilt 1993 · S/N 21633 N164MSHose Louise D · Dayton, NVBuilt 1990 · S/N 20004 N164MTTaylor Michael S · Phoenix, AZBuilt 2006 · S/N 25589 N164RGGlass Roy L · Cardiff By The Sea, CABuilt 2005 · S/N 60266 N164RSCarter David C · Temple, TXBuilt 1995 · S/N 21168 N164SPClay David L · Bryceville, FLBuilt 1997 · S/N ML01 N164SWNew England Aviation LLC · Plainville, CTBuilt 1975 · S/N 28-7690077 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 N1650JQureini Khalil H Vii · Kansas City, MOBuilt 1967 · S/N 28-24043 N16513Ashworth Diane A Executor · Chase City, VABuilt 1973 · S/N 28-7305273 N1651ENoffsinger Robert L · Winston Salem, NCS/N 17271081 N16526Wesley Joseph L · Pismo Beach, CABuilt 1973 · S/N 28-7325291 N16527Skolnick Sanford M · Novato, CABuilt 1973 · S/N 28-7305274

Back to AD 80-04-03 R2