Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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:2006-16-18-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.

N3270RMotorman Of America Corp · Wilmington, DEBuilt 1995 · S/N E-2970 N3271GPettit James P · Newport, VABuilt 1995 · S/N E-2971 N3271VRiley Daniel B · Valparaiso, INFirst renewal noticeBuilt 1947 · S/N D-720 N3272VWooldridge Homes LLC · New Haven, KYBuilt 1995 · S/N E-2972 N3273VRoberts Alan P · Bolivar, MOBuilt 1947 · S/N D-722 N3276VGrubbs Terry · Gregory, SDBuilt 1947 · S/N D-725 N327BADamandan Air Enterprises LLC · Gallatin, TNBuilt 1980 · S/N BE99 N327GSkysix Aircraft Management LLC · Saginaw, MIBuilt 1994 · S/N E-2910 N327HWN327hw LLC · Amarillo, TXS/N 560-0373 N327LCNeptune Agricultural Group Inc · Vero Beach, FLS/N BB1427 N327MEReach Co LLC · Hughson, CABuilt 1987 · S/N FA-127 N327RHealth Care Capital Of North Carolina LLC · Atlanta, GABuilt 1999 · S/N FL-259 N327RBAerial Applicators Of Missouri LLC · Pollard, ARBuilt 1978 · S/N BB-335 N327WLSouth Aero Inc · Albuquerque, NMBuilt 1996 · S/N 208B0547 N3281KWallace Architects LLC · Columbia, MOBuilt 1979 · S/N TH-1006 N3288VSimmons Shawn Noral · Fort Rock, ORS/N D-739 N328CJRegistration Pending · College Grove, TNRegistration pendingBuilt 1999 · S/N 525-0328 N328CRDmg Aero LLC · Hickory, NCBuilt 1979 · S/N BB-548 N328HHGeorge James W · Tullahoma, TNBuilt 1992 · S/N E-2752 N328JKJk Aviation Venture LLC · Windermere, FLBuilt 2026 · S/N 208B5957 N328MN328m LLC · Marion, INBuilt 2001 · S/N TH-1992 N328NAN186sb LLC · Stuart, FLBuilt 1980 · S/N 501-0168 N328PStrother J Barron · Santa Rosa Beach, FLBuilt 1999 · S/N TH-1916 N328RED & R Ezzell Inc · Rockwall, TXBuilt 1983 · S/N 31T-8166068 N329AJKnox Flocks LLC · Knoxville, TNS/N FL-498 N329ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-329 N329GSAugusta Aviation Inc · Hilton Head Island, SCBuilt 1992 · S/N LJ-1320 N329JHAlliance Aircraft Sales Inc · Pierre, SDBuilt 1976 · S/N E-870 N329MAfd Aviation LLC · Dallas, TXS/N E-3490 N329PVN329pvrtbkcitation5 LLC · Las Vegas, NVBuilt 1991 · S/N 560-0140 N329TJForsythe Aviation LLC · Point Lookout, MOS/N 120 N329ZAKalitta Air LLC · Ypsilanti, MIBuilt 2003 · S/N 32914 N32BBGee Aviation Inc · Sturgis, KYBuilt 2019 · S/N 525-1026 N32ELCoastal Air LLC · Naknek, AKBuilt 2002 · S/N 208B0960 N32FBWilmington Trust Co Trustee · Wilmington, DEBuilt 2018 · S/N FL-1147 N32KBS S K Hawker Group LLC · New Haven, CTBuilt 2000 · S/N 258461 N32LJCrocker LLC · Missoula, MTBuilt 1981 · S/N BB-993 N32MBMarin Airmen Inc · Mill Valley, CABuilt 1969 · S/N E-160 N32MJAviation Company Inc · Cheyenne, WYBuilt 1982 · S/N 460 N32NHIsr Platforms LLC · Mclean, VABuilt 2017 · S/N 208B5360 N32PJRegistered aircraftN-number assigned (import), not yet registeredS/N NA0455 N32RHPor Aviation LLC · Huntersville, NCBuilt 1990 · S/N LJ-1268 N32SVDoorless Leasing LLC · Lewes, DEBuilt 1981 · S/N BB-865 N32TAVan Wyk Kenneth W · Pella, IABuilt 1968 · S/N E-120 N32TPIal Corp · Lewes, DEBuilt 1979 · S/N BB-456 N32WAWright Air Service Inc · Fairbanks, AKBuilt 1991 · S/N 208B0234 N32WHEagle Air Partners LLC · Bartlett, TNBuilt 1977 · S/N E-1184 N3300GAir Amg LLC · Greensboro, NCBuilt 1977 · S/N TH-869 N3300VJacobsen Glenn D · Plano, ILBuilt 1947 · S/N D-759 N3304VConklin Greg · Nevada City, CABuilt 1947 · S/N D-763

Back to AD 2006-16-18 R1