Registered aircraft · 13,518

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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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:99-05-13-R1-WD')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
  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:99-05-13-R1-WD')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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.

N50HTDunteman William M · Big Rock, ILBuilt 1960 · S/N HH-131 N50JMMinter Michael D Jr Trustee · Rock Port, MOBuilt 1978 · S/N D-10141 N50LAMorris Industries Inc · Wichita, KSS/N EA-307 N50LWFlyer One LLC · Palm Harbor, FLBuilt 1970 · S/N TE-790 N50SBCobb Susie O · Fayetteville, TNBuilt 1978 · S/N TC-2134 N50TMRegistration Pending · Williamson, WVRegistration pendingBuilt 1972 · S/N MB-552 N50WAClements Bruce · The Villages, FLBuilt 1962 · S/N BA-616 N50ZTackes Steven · Carson City, NVBuilt 1969 · S/N D-8929 N5100CClefton Gordon A · New Creek, WVBuilt 1950 · S/N D-2362 N5101MCarlson Noah · Seattle, WAS/N M-2033 N5101RVan Steenis William W · Boulder City, NVS/N MB-788 N5102MRegistration Pending · West Melbourne, FLRegistration pendingBuilt 1978 · S/N M-2032 N5105CColston David T · Vero Beach, FLS/N D-2386 N5105RSale Reported · Colville, WASale reported, pending cancellationBuilt 1974 · S/N MB-639 N5106MMathews Mark · Cottrellville, MIBuilt 1978 · S/N MC-578 N5106RBenson Robert W · Wichita Falls, TXS/N MB-640 N5107MBahus Jason · La Porte, INBuilt 1978 · S/N M-2027 N5108CLee Brandon Thomas · Pace, FLBuilt 1950 · S/N D-2389 N5109CCurry Demetrius · Kansas City, MOS/N D-2387 N510CHTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9999 N510TCSkyview Aviation LLC · Hartwell, GAS/N E-1469 N5111RAlpine Aviation LLC · Oasis, IDBuilt 1974 · S/N MB-645 N51121Bromschwig Kurt F Trustee · Montgomery, TXBuilt 1945 · S/N 4914 N5112CDelaware Aircraft Trust LLC Trustee · New Castle, DES/N D-2395 N5113RHamaker Nevada C · Bothell, WABuilt 1974 · S/N MB-647 N5114RHayden Steven E · Westminster, COBuilt 1974 · S/N MB-648 N5115RMichael D Woods LLC · Harleton, TXBuilt 1977 · S/N M-1974 N5116MBend Aircraft Mechanics LLC · Bend, ORBuilt 1978 · S/N ME-39 N5116RSajdak Brian Christopher · Hernando, MSBuilt 1979 · S/N M-2164 N5117CPerazzo Enterprises Inc · Brookeland, TXS/N D-2402 N5118CHammill Michael R · Alamance, NCS/N D-2403 N511CMartin Gary N · Lake Jackson, TXBuilt 2004 · S/N E-3576 N511FClarke Kenneth J · Anchorage, AKBuilt 1963 · S/N TC-555 N511RAKeenan Michael John Trustee · Anchorage, AKS/N E-2746 N511SPFassas Alexander D · Richmond, KYBuilt 1976 · S/N E-910 N511TEPieroni Corp · Clermont, FLNon-citizen corporation, flight hours not reportedS/N TE511 N511VMRadler Glenn · Livingston, NJBuilt 1964 · S/N TC-785 N5120RKrause Aviation LLC · Geneva, ILS/N TC-1816 N5124CKansas Aviation Museum · Wichita, KSBuilt 1950 · S/N D-2409 N5124MWerner James J · Cave Creek, AZBuilt 1978 · S/N MC-576 N5125MSampson Alan T · Indianapolis, INBuilt 1978 · S/N M-2030 N5126CUlmer Eric R · StockholmBuilt 1950 · S/N D-2411 N5128CLacey Nora B Trustee · Incline Village, NVBuilt 2002 · S/N E-3455 N512BDTurbo Aviation LLC · Chesterfield, SCS/N D-9398 N512SLSalmon Raymond A Trustee · Tavares, FLBuilt 1984 · S/N TJ-472 N5130CGuy Jeffrey · Centerburg, OHBuilt 1950 · S/N D-2415 N5130XHofferth Brian K · Anacortes, WABuilt 1959 · S/N D-6039 N5135CPogorelec Michael · Beaver Dam, WIS/N D-2420 N5137BTextron Aviation Inc · Wichita, KSFirst renewal noticeBuilt 2007 · S/N E3547 N5137CSandegren Lars F · Lake Saint Louis, MOBuilt 1950 · S/N D-2422

Back to AD 99-05-13 R1 WD