Registered aircraft · 108,433

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.

N20845Clark Bradley D · Kirkwood, ILFirst renewal noticeS/N 18261252 N20848Lown Jeffrey B II · Shrewsbury, NJBuilt 1979 · S/N 28-7911080 N20849Tradewind Ventures LLC · Evans, GABuilt 1999 · S/N 30-0017 N2084ASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995081 N2084DWaves4days LLC · El Segundo, CABuilt 2004 · S/N SRG061 N2084EBuchholz Steve DBA · Clarkston, MIBuilt 1978 · S/N 17271148 N2084GFlying Farmers LLC · Hills, MNBuilt 1958 · S/N 51384 N2084PSchalk Bretta J · Fountain Run, KYBuilt 1956 · S/N 23-672 N2084RTej Builds Air LLC · Winchester, VABuilt 1964 · S/N 18255284 N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050 N2084THeiss Bryan G · Shelby, MIBuilt 1970 · S/N 28R-7135028 N2084WBurkett James Austin III · New Port Richey, FLBuilt 1965 · S/N D-8009 N2084XPrier Duncan M · Bonita Springs, FLBuilt 1965 · S/N 18256184 N20852Spaulding Kenneth L · Sahuarita, AZBuilt 1972 · S/N 18261258 N20854Branson Bonanza Club · Branson, MOBuilt 1972 · S/N 18261260 N20855Mission Aviation LLC · Billings, MTBuilt 1972 · S/N 18261261 N20856Pointon Martin J · Snohomish, WABuilt 1972 · S/N 18261262 N20858Vintage Flyers Inc · Napa, CABuilt 1974 · S/N 17263857 N20859Anderas Per R · Green Bay, WIS/N 18261264 N2085GBackcountry Guys LLC · Prescott, AZS/N 51385 N2085LFly More Drive Less LLC · Hot Springs, ARBuilt 1976 · S/N D-9908 N2085POphelia Aviation LLC · Paradise Valley, AZBuilt 1979 · S/N 28-7911102 N2085SRichards John · Casa Grande, AZBuilt 1975 · S/N 21061051 N2085TBlue Skies Aircraft LLC · Kalispell, MTS/N 28R-7135029 N2085VForbes Aviation LLC · Boise, IDBuilt 1979 · S/N 28-7990337 N2085XBrian Murray J · Pekin, ILBuilt 1965 · S/N 18256185 N2085YLima Romeo Kilo Golf Lp · Worthington, INBuilt 1973 · S/N 18502151 N20862Barrington Aviation LLC · Kalamazoo, MIBuilt 1972 · S/N 18261267 N20864Dishart Bradley E · Gibsonia, PABuilt 1978 · S/N 28-7990026 N20865Agasair LLC · East Hampton, NYBuilt 1974 · S/N 17263859 N2086GHigh Country Aces LLC · Cove, ARBuilt 1958 · S/N 51386 N2086LMortensen Daniel R Trustee · Newhall, CABuilt 1976 · S/N CE-658 N2086PSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1956 · S/N 23-674 N2086RRobison Robert S · Collinsville, ILBuilt 1969 · S/N 28-5458 N2086TEllis Amy E · Santa Rosa, CABuilt 1970 · S/N 28R-7135030 N2086WSanders Flight Training Center LLC · Jasper, ALS/N TD-644 N2086XPerron Joseph R · Jasper, GABuilt 1965 · S/N 18256186 N20870Willis David A · Thief River Falls, MNBuilt 1972 · S/N 18261274 N20871High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17263862 N20873Mang Aero Club · Belleville, MIBuilt 1978 · S/N 28-7990027 N20876Ogalalla Land & Cattle Ltd · Douglas, WYS/N 17263863 N20877Teton Leasing LLC · Pocatello, IDBuilt 1972 · S/N 18261279 N2087DIsaac Mohsen · Venetia, PABuilt 1978 · S/N 28-7911031 N2087EPcs Aviation LLC · La Canada, CABuilt 1978 · S/N 17271150 N2087FH & M Ltd · Warren, IDS/N 18264886 N2087GTate Frederic H S DBA · Marfa, TXBuilt 1958 · S/N 51387 N2087L30 West Pilots LLC · Dover, DEBuilt 1976 · S/N TC-2007 N2087NRls Rental Co DBA · Joplin, MOBuilt 1979 · S/N 28-7916253 N2087PGold Mountain LLC · Kalispell, MTBuilt 1977 · S/N 36 N2087RMangus Ricky Alan · Kent, WABuilt 1964 · S/N 18255287

Back to AD 2007-04-19 R1