Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N415WMFour Wynns Aviation Llp · Stansbury Park, UTBuilt 1999 · S/N 1005 N4161AKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2000 · S/N 3449160 N4168DAnanas Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 3449158 N4168TTan Resources LLC · Bondurant, IABuilt 2000 · S/N 3449166 N4170HBridges Kevin J · Clemmons, NCBuilt 2002 · S/N 3449259 N4174DB L Duke Inc · Joliet, ILBuilt 2000 · S/N 3449178 N417MKRegistration Pending · Reno, NVRegistration pendingBuilt 1977 · S/N 28R-7703192 N41849Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 3449179 N418DPPiotrowski Enzo · Miami, FLBuilt 1976 · S/N 34-7670239 N419HCZangs William J · Poplar Grove, ILBuilt 1978 · S/N 34-7870376 N41EJDutta Sandeep · Foster City, CABuilt 1980 · S/N 25-0499 N41FGHousley William M · Jasper, ALBuilt 1966 · S/N R1720093 N41GFMesmer Refrigeration Inc · Buffalo, NYBuilt 1977 · S/N 28R-7703083 N41ZMMindwinder Inc · Reno, NVBuilt 1977 · S/N 34-7870018 N420CPPerez Jorge A · Mission, TXS/N 1060 N420KBPierson Bradley A · Anchor Point, AKS/N 6097C N420PBZarot LLC · Long Branch, NJBuilt 2003 · S/N 1288 N421DWLandman William L · Snowmass, COBuilt 1979 · S/N 28R-7931044 N423CCAllen Stephen David · Los Banos, CABuilt 1978 · S/N 28R-7803368 N423RHHunt Robert H · Taylorsville, MSBuilt 1971 · S/N 33701420 N423SV & L Enterprises LLC · Wilmington, DEBuilt 1981 · S/N 34-8233071 N424Ross Michael J · Los Angeles, CABuilt 1976 · S/N P3370259 N424AFMayer Christopher T · Springboro, OHBuilt 1967 · S/N 67-21424 N424CDAirfleet Solutions LLC · Newark, DEBuilt 2004 · S/N 1439 N424TATamkin Asset Management LLC · Malibu, CABuilt 1981 · S/N 34-8133044 N424XCEchelbarger Todd · Edmonds, WABuilt 1990 · S/N 344-8005 N425KPlane Fun Inc Tr Trustee · Snellville, GABuilt 1979 · S/N 28R7931243 N425SJCook Christopher J · Baxley, GABuilt 2003 · S/N 1342 N4277BHale Barbara M · Oxnard, CABuilt 1977 · S/N R1722556 N4277VBoyd William L · Hillsboro, ORS/N 18635 N427HPBohannon Brian · Prosper, TXBuilt 2005 · S/N 1528 N427VKNichols Vikki J · Williamson, GABuilt 1967 · S/N 337M0133 N42850Ogren Craig R · Berlin, CTBuilt 2010 · S/N 2678081 N428RJSeneca Ez LLC · Weston, FLBuilt 1975 · S/N 347570250 N4293CNussbaum Rod M · Bradenton, FLS/N 28R-8331024 N4293XTimothy G Turner · Oklahoma City, OKBuilt 1983 · S/N 34-8333043 N42946Perchard Baron D · Schaumburg, ILBuilt 1983 · S/N 28R-8331025 N42970Digbus Aviation LLC · Sheridan, WYS/N 28R-8331030 N4297YPalmer John · Duluth, MNBuilt 1983 · S/N 28R-8331029 N429SBieker James · Eatonville, WABuilt 2004 · S/N 1399 N429TLLong Tracey · Cleveland, TNBuilt 1974 · S/N 34-7570001 N42HHHageness Donna L · Rolette, NDBuilt 1977 · S/N 34-7770093 N42PGWright Charles E · Hebron, KYBuilt 1977 · S/N 28R-7703353 N42WWZahler Mitchell J · Stillwater, MNS/N 3688 N43010Nahigian J Victor · Weston, MABuilt 1983 · S/N 34-8333075 N4303WDickhead Aviation LLC · Smithfield, NCBuilt 1983 · S/N 34-8433016 N4304XC W Rose Flight LLC · Wilmington, DEBuilt 1976 · S/N 34-7670018 N4310JTahaney David J · Fox Lake, ILS/N 28R-8331043 N4311UMoreland Wesley M · Mckinney, TXBuilt 1965 · S/N 337-0093 N4318MDelaware Aircraft Holdings Inc · Wilmington, DEFirst renewal noticeBuilt 1984 · S/N 28R-8431001

Back to AD 81-13-10 R1