Skip to content

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.

N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008 N158WUYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496158 N15901Harbor Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7310073 N15909Downes Pamela M · Chino Hills, CABuilt 1972 · S/N 28R-7335104 N1590JTidwell Kevin C · Kennesaw, GABuilt 1967 · S/N 28-23999 N1590VWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17263684 N1590XLanders Stephen F · Riverview, FLBuilt 1975 · S/N 28R-7535344 N15914Studt Joseph Floyd · Rockvale, COBuilt 1972 · S/N 28-7325197 N15916Marianas Air Transfer Inc · Tinian, MPBuilt 1972 · S/N 28-7325199 N15918Ramseier Peter A · Imperial Beach, CAS/N 28-7305185 N15919Tikhomirov Anton · Ashland, MABuilt 1973 · S/N 28R-7335106 N1591EWingsleasing LLC · Wichita, KSBuilt 1978 · S/N 17271057 N1591JWingard Edward J · Powell, OHBuilt 1968 · S/N 28-24001 N1591VAviation Academy LLC · Wichita, KSBuilt 1974 · S/N 17263685 N1591WMuraszko Raymond P · Monroe, NJBuilt 1972 · S/N CE-381 N1591XTask Aviation LLC · Vancouver, WABuilt 1975 · S/N 32-7540180 N15925Everglades Aviation Academy LLC · Weston, FLBuilt 1973 · S/N 34-7350109 N159274dw Interests LLC · Longview, TXBuilt 1973 · S/N 28-7325202 N15928Bussell Matthew W · Reno, NVBuilt 1973 · S/N 28-7305187 N15929Cs Flying Ltd · Grafton, OHBuilt 1972 · S/N 28-7305188 N1592CPulver Douglas A · Kenockee, MIBuilt 1953 · S/N 30292 N1592LLwcr Transportation Inc · Minot, NDBuilt 1976 · S/N E-832 N1592MDumais Robert J · Tilton, NHBuilt 1975 · S/N 18264382 N1592SRoach Christopher A · Mustang, OKBuilt 1962 · S/N CD-471 N1592VGates Kenneth A · Lake Isabella, CABuilt 1974 · S/N 17263686 N1592WDebonair Flying Club Inc · Medon, TNBuilt 1972 · S/N CE-383 N1592XN2211z LLC · Lantana, FLBuilt 1975 · S/N 28-7515427 N15930Rogers Aviation LLC · Florence, SCBuilt 1973 · S/N 28-7305189 N15931Smitty 172 LLC · Rockford, MIS/N 28R-7335108 N15933Flaps Inc · White Bear Lake, MNBuilt 1973 · S/N 28-7325203 N15935Stahl Dennis E · Wood Dale, ILBuilt 1973 · S/N 28-7305190 N15936Brown Norman C · Kewanee, ILS/N 28-7305191 N15939Ray H Gregg · Nashville, GABuilt 1973 · S/N 32-7300021 N1593CPeacock Richard M · Swansboro, NCS/N 30293 N1593JRindeikis Bron · Sugar Grove, ILS/N 28-24003 N1593LBurr Walter E · Tecumseh, MIBuilt 1976 · S/N CE-637 N1593SHoward Paul D Jr · Williamson, WVS/N D-7013 N1593VBarrie Woodrow L · Oxford, MIBuilt 1974 · S/N 17263687 N1593XVaniscak Greg A · Fort Collins, COBuilt 1975 · S/N 28R-7535345 N1593YBolsover Douglas J · Cameron Park, CABuilt 1962 · S/N 17249293 N1593ZButler Richard Austin · Gatesville, TXBuilt 1961 · S/N D-6885 N15943Edgerton Eddie Lee · Midwest City, OKBuilt 1973 · S/N 28-7325208 N15944Habit Samuel P · Kokomo, INBuilt 1973 · S/N 28-7305193 N15945Newton Flying Club Inc · Collinsville, MSBuilt 1972 · S/N 28-7305194 N15946Leading Edge Inc · Cottonwood Heights, UTBuilt 1973 · S/N 28-7305195 N1594CFlyrs Field · Anchorage, AKBuilt 1953 · S/N 30294 N1594LIntermill Alice R · Volga, SDBuilt 1976 · S/N E-833 N1594UFarmer Michael E · Greer, SCBuilt 1976 · S/N 17267176 N1594WFinnigan Jeffry A · Hoodsport, WABuilt 1972 · S/N CD-1290 N1594XPiper Flyers LLC · Zionsville, INBuilt 1975 · S/N 32R-7680004

Back to AD 98-21-21 R1