Registered aircraft · 2,131

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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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.

N111JFJoyce Aviation Inc · Winston Salem, NCBuilt 1981 · S/N 31T8120012 N111MYMeshed Networx LLC · New Market, VABuilt 1978 · S/N 27-7854092 N111UCRcht LLC · Mason, OHBuilt 1979 · S/N 31-7952190 N1123PRegistration Pending · Flint Hill, VARegistration pendingS/N 23-133 N1131PDBA Congdons Aviation Service · Anchorage, AKS/N 23-141 N1132PR & S Stuart Co Inc · Wilmington, DEBuilt 1955 · S/N 23-142 N1134PSutton Aircraft Salvage LLC · Palmer, AKBuilt 1955 · S/N 23-146 N113JBMcdonald Aviation Inc · Knoxville, TNBuilt 1960 · S/N 27-226 N1140PCromley Amanda J · Lewisburg, PABuilt 1955 · S/N 23-152 N114BAAustin Bill DBA · Sparta, TNS/N 42-8001027 N114NCFair Air Inc · Bloomfield Hills, MIS/N 31-8252009 N114PRC W 3 LLC · San Juan, PRBuilt 1981 · S/N 31-8152088 N114SACustom Air International LLC · Homestead, FLBuilt 1980 · S/N 31-8052053 N1157SDig2fly LLC · Sandpoint, IDBuilt 1978 · S/N 317812093 N1158PLorenzo Walker Institute Of Tech · Naples, FLBuilt 1955 · S/N 23-171 N115BMAshland Water Group · Ashland, OHBuilt 1982 · S/N 31T-8120053 N115JDC R Aviation Inc · Miami, FLS/N 27-7405395 N115PCDodson International Parts Inc · Pelkie, MIBuilt 1977 · S/N 31T-7820001 N1166PDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1955 · S/N 23-180 N1167PCascadia Air Ventures Inc · Winlock, WABuilt 1955 · S/N 23-181 N116MFWeber Donald E · Saint David, AZS/N 27-3522 N1172PSteed William B · Winnsboro, SCS/N 23-175 N1174PHardin John M · Terrell, TXBuilt 1955 · S/N 23-188 N117JPSanborn Map Company Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612086 N1183GC A R Lease Corp · Brentwood, TNBuilt 1979 · S/N 31T-7920086 N1187KLove Simplicity · Princeville, HIBuilt 1980 · S/N 318052175 N1189PParks Eric · Matthews, NCBuilt 1955 · S/N 23-203 N118HBTd Air LLC · Cromwell, CTBuilt 1980 · S/N 31T-8004052 N118MCAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952161 N118WCHalair Inc · Diablo, CABuilt 1979 · S/N 31T-8020020 N1197PPenley Steven A · Corinth, TXBuilt 1955 · S/N 23-212 N11MPAtwill Brock · Paragould, ARBuilt 1972 · S/N 27-4821 N11MTSpeedy Aviation LLC · Liberty, SCBuilt 1978 · S/N 27-7854064 N11PZCentral Virginia Flyers LLC · Palmyra, VABuilt 1971 · S/N 27-4699 N11SBGrant Zachary J · Indianapolis, INBuilt 1976 · S/N 31-7612062 N11TDDuflo Spray Chemical Inc · Lowville, NYBuilt 1960 · S/N 27-271 N1207PN73481 LLC · Ault, COBuilt 1955 · S/N 23-223 N120DUnited States Air Force Owner · Hanscom Afb, MABuilt 1972 · S/N 27-4799 N120JDLamb Aviation LLC · Perris, CABuilt 1981 · S/N 31-8152179 N120LPGramer Air IV LLC · Northville, MIBuilt 1977 · S/N 31-7812010 N120MLMrl Aviation LLC · Wilmington, DEBuilt 1977 · S/N 31-7752091 N1210PRegistration Pending · Independence, MORegistration pendingBuilt 1955 · S/N 23-226 N1215PTucker Robert B · Melba, IDBuilt 1955 · S/N 23-234 N1217Pendley Rory G · Torrance, CABuilt 1955 · S/N 23-237 N121LHTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 425501049 N121SLLadet David E · Lavonia, GABuilt 1969 · S/N 27-4475 N1220BWash Steven M · Austin, TXBuilt 1957 · S/N 23-1161 N122AWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1976 · S/N 31-7652135 N122DDBeacon Hill Leasing LLC · Plymouth, MIBuilt 1977 · S/N 27-7754120 N1231PTwin Oaks Airpark Inc · Hillsboro, ORBuilt 1955 · S/N 23-251

Back to AD 2009-13-06 R1