Registered aircraft · 108,428

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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.

N158TBLunt Christopher K · Marco Island, FLBuilt 1977 · S/N TH-826 N158TCBoyd Brent · Fort Worth, TXBuilt 1978 · S/N TK-68 N158UUtah State University · Logan, UTBuilt 2025 · S/N 40.1254 N158WCKing Air Properties LLC · Huntington Beach, CABuilt 2001 · S/N TH-2008 N158WUYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496158 N158YBCommercial Bank Aviation LLC · Harrogate, TNBuilt 2014 · S/N TH-2410 N158ZLOlds Curtis J Jr · Elizabeth City, NCBuilt 1957 · S/N BG-344 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 N1590WCc Aviation Inc · Tracy, CABuilt 2005 · S/N 17281256 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 N1591FBaer Monte Wayne · Ronan, MTBuilt 1966 · S/N 185-0973 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 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 N1592FReynolds Frederick A · Pilot Point, AKBuilt 1966 · S/N 185-0974 N1592LLwcr Transportation Inc · Minot, NDBuilt 1976 · S/N E-832 N1592MDumais Robert J · Tilton, NHBuilt 1975 · S/N 18264382 N1592RWilliams Brian S · Marietta, GABuilt 1975 · S/N AA5B-0092 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 N1593RReichenbach Richard R · Frankfort, MIBuilt 1993 · S/N 676 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 N1593ZButler Richard Austin · Gatesville, TXBuilt 1961 · S/N D-6885 N15943Edgerton Eddie Lee · Midwest City, OKBuilt 1973 · S/N 28-7325208

Back to AD 2007-04-19 R1