Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N188GWBrown Die Casting & Manufacturing Inc · Royse City, TXBuilt 1979 · S/N 421C0613 N188SRRogers Steven Trustee · Ogden, UTBuilt 1978 · S/N 340A0636 N188WW3l0 Air LLC · Chuluota, FLBuilt 1976 · S/N TJ-67 N188YMbaa Holding LLC · Myrtle Beach, SCBuilt 1964 · S/N TC-790 N1890MPutney Bruce N · Midlothian, TXS/N 33701490 N18929Vector Aviation LLC · Mentor, OHBuilt 1978 · S/N ME-6 N18941N18941 LLC · Boynton Beach, FLBuilt 1978 · S/N ME-8 N1894EDelvest LLC · Grosse Pointe, MIBuilt 1979 · S/N 340A0662 N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894 N1896LGolf Lima Aviation LLC · Port Angeles, WABuilt 1976 · S/N TK-16 N1896SSky Dds LLC · Las Vegas, NVBuilt 1998 · S/N 3449088 N1897LHrt Aviation LLC · Southlake, TXBuilt 1976 · S/N TC-1971 N189MKS2ar Aviations LLC · Lantana, FLBuilt 1978 · S/N 414A0100 N189MLStrobe Aviation LLC · Columbia, SCBuilt 1977 · S/N 34-7770114 N189MWWilliamson Aviation Inc · Tullahoma, TNBuilt 1968 · S/N 310N-0003 N189SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 31-7512045 N18EGBoanco Inc · Lafayette, INBuilt 1973 · S/N 414-0394 N18HLBusinessliner Inc · Ft Lauderdale, FLBuilt 1980 · S/N 31-8052055 N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651 N18MRMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 340A0557 N18MWRed State LLC · Daytona Beach, FLBuilt 1967 · S/N 27-3691 N18NRWonderful Pistachios & Almonds LLC · Lost Hills, CABuilt 2018 · S/N 20800610 N18RJDocs Air LLC · Diamondville, WYS/N 27-4382 N18RKJacksonville Twin Comanche LLC · Kalispell, MTFirst renewal noticeBuilt 1979 · S/N 34-7970151 N18RLAlpha Whiskey 3 LLC · Brandon, MSBuilt 1979 · S/N 31-7952090 N18SCSpencer Clyde V · Queen Creek, AZBuilt 1977 · S/N TJ-111 N18TN18t Ltd · Wilmington, DEBuilt 1968 · S/N 421-0144 N18TCAviotti Inc · Henderson, NVBuilt 1978 · S/N 421C0503 N18TPPotter Todd J · Warrens, WIBuilt 1979 · S/N 34-7970431 N18VJAssurance Data Inc · Indiana, PABuilt 1984 · S/N TJ-445 N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771 N1901LBerry Darrel · Camden, TNBuilt 1976 · S/N TH-754 N1905B605 Aviation LLC · Aberdeen, SDBuilt 1978 · S/N 414A0214 N1905ERusso Louis A Jr · Houston, TXBuilt 1979 · S/N 340A0664 N190DCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496103 N190RSBas Part Sales LLC · Greeley, COBuilt 1977 · S/N TH-804 N1918EGuano Air LLC · Palmetto Bay, FLBuilt 1979 · S/N 340A0668 N1919VHigh Mountain Properties LLC · Idaho Falls, IDBuilt 1984 · S/N T30300271 N191AMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 31P-7630012 N191FPravin Aturalita · Duluth, MNBuilt 1964 · S/N TC-716 N191LRRoutman Leone Aircraft LLC · Fort Lauderdale, FLBuilt 1994 · S/N TH-1720 N191NDMoore Aviation Inc · Beaver Falls, PABuilt 1989 · S/N 4495003 N191WFletcher Flying Service 419 LLC · Labelle, FLBuilt 1964 · S/N TC-577 N1920EHappy Trails Flight Training & Charters LLC · Helena, MTBuilt 1979 · S/N 340A0669 N1925GEfi Technology Inc · Cave Creek, AZBuilt 1975 · S/N 421B0826 N1925JBuzco Aviation LLC · Thomaston, GABuilt 1966 · S/N 337-0431 N192AFWarren E Mack LLC · Minneapolis, MNBuilt 1980 · S/N 414A0496 N192CSDodson International Parts Inc · Rantoul, KSBuilt 1973 · S/N 31P-7300138 N192QFisher Robert · Shoreacres, TXS/N TC-783 N1942GBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 421B0842

Back to AD 2004-25-16 R1