Registered aircraft · 1,041

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

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N100BRIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N LA-116 N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890 N100TWTexas La Flyers LLC · Monroe, LABuilt 1978 · S/N BE-51 N101SGSe Aviation LLC · Tupelo, MSBuilt 2001 · S/N BB-1785 N101SNGorsuch Aviation LLC · Lancaster, OHBuilt 1981 · S/N BE-118 N102DBFinch Air LLC · Midland, TXBuilt 1996 · S/N BB1537 N102WKWillis Knighton Medical Center · Shreveport, LABuilt 1980 · S/N LA-36 N104CXSli Aircraft Leasing Inc · Spokane Valley, WABuilt 1982 · S/N BB1004 N106GBHardhead Aviation LLC · Midland, TXBuilt 1986 · S/N BB-1249 N106RHSouthern Bracing Systems Inc · Armuchee, GABuilt 1978 · S/N BB-428 N1074GEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1534 N108ALRj Flight LLC · Saint Petersburg, FLBuilt 1980 · S/N BB-730 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N108EBAndrie Inc · Muskegon, MIBuilt 1980 · S/N BE-108 N108RJDixon John W · Aurora, ORBuilt 2002 · S/N BB-1801 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N109MDM B Duncan Inc · Bakersfield, CABuilt 1985 · S/N BB-1213 N10AGBaron Associates LLC · Norfolk, VABuilt 1980 · S/N BE-100 N10CW911 Aviation LLC · Durant, OKBuilt 1985 · S/N BB-1211 N10DHVta Capital LLC · Ontario, CABuilt 1981 · S/N LA-111 N10QWBlackhawk 04 LLC · Portland, ORS/N BB-1846 N110GGo Soar LLC · Highland Village, TXBuilt 1980 · S/N BB-792 N1114KRogers John Stuart Trustee · Hughson, CABuilt 1997 · S/N BB-1559 N111AABlue Water Aviation LLC · Vestavia, ALS/N LA-6 N111CAKingmax Aviation LLC · Miami, FLBuilt 1982 · S/N LA-201 N111ENPecos Air Inc · Roswell, NMS/N LA-230 N111MQBismarck Air Medical LLC · Bismarck, NDBuilt 1999 · S/N BB-1665 N111PVHenson Builders LLC · Dallas, TXBuilt 1981 · S/N BB-772 N113SHHill Lawrence E · Marion, MTBuilt 1970 · S/N B-18 N114CWMatagorda Production Co · Houston, TXBuilt 1980 · S/N LA97 N114HBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1533 N115CTChastang Lawrence · Orlando, FLBuilt 1999 · S/N BB-1669 N116DGStructures Inc · Mesa, AZBuilt 1981 · S/N BE-116 N116TXPlacid Air LLC · Naples, FLBuilt 1999 · S/N BB-1685 N117TJCoastal Community Real Estate Group LLC · Caswell Beach, NCBuilt 1980 · S/N LA17 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N118NLPandd Partnership LLC · Oro Valley, AZBuilt 1981 · S/N BE-111 N118SBEaglemed LLC · Wichita, KSBuilt 1996 · S/N BB-1541 N119ARCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N BB-1867 N119MCAgave III LLC · Seattle, WABuilt 1985 · S/N BB-1225 N11WNRds Aviation LLC · Elkhart, INBuilt 1982 · S/N LA177 N120NCDavis Aviation Inc DBA · Brandon, MSBuilt 1982 · S/N BB1056 N120RLIsr Platforms LLC · Mclean, VABuilt 1979 · S/N BT-9 N121DKAutomotive Air II LLC · Belcamp, MDBuilt 2007 · S/N BB-1995 N121LBEastern Stearman Inc Trustee · Leesburg, VAS/N BB-475 N122BKFlying Mixers LLC · Amarillo, TXBuilt 1999 · S/N BB-1651 N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32 N123CHMdi Air LLC · Dothan, ALBuilt 1980 · S/N LA-32 N123MLNfbn LLC · Scottsdale, AZBuilt 1997 · S/N BB-1587

Back to AD 96-03-13