Registered aircraft · 44,906

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-10-21') 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-10-21') 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-10-21')
    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-10-21')
  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-10-21')
  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-10-21')
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.

N102WMStar Air Service LLC · Jacksonville, FLBuilt 1981 · S/N 31-8152112 N102WPGarcia Randy S · Montebello, CABuilt 1991 · S/N S1572 N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319 N1030ZLenhart Thomas E · Barnesville, GABuilt 1997 · S/N 23041C N1031XJj Byrne International Inc · Steamboat Springs, COS/N T18208268 N10329Lissow William M · New Port Richey, FLS/N 22018C N1032JKornegay Kenneth D · Roanoke, VABuilt 1973 · S/N 32 N1032SThurber Matthew Calbraith · Vancouver, WABuilt 1980 · S/N 144-H N10339Yarbro Floyd A · Kenton, TNBuilt 1997 · S/N 21022C N1033AAtlas Aviation Tampa Inc · Tampa, FLBuilt 2005 · S/N 17281238 N1033CHuson Lee E · Port Townsend, WABuilt 1997 · S/N 25012C N1033TManzo Deborah S · Lake Placid, FLBuilt 1973 · S/N 27-7405302 N1033YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2007 · S/N 172S10598 N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198 N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222 N1036JPremier Jets Inc · Hillsboro, ORS/N 36 N1036LN1036l Corp · Wilmington, DEBuilt 1976 · S/N 27-7654135 N1036MMangon Aircraft Inc · Petaluma, CABuilt 2007 · S/N 172S10599 N1036NKovaleski Thomas J · Chugiak, AKBuilt 1997 · S/N 23035C N1036XMotley Douglas Trustee · Rehoboth Beach, DEBuilt 1975 · S/N 32-7540131 N10375Tactical Turtle LLC · Ortanna, PAS/N 67-18376 N1037JTate Andrew E · Chapel Hill, NCBuilt 1973 · S/N 37 N1038JLandgraf Robert J · Sussex, WIBuilt 1973 · S/N 118 N1038NSome Beech LLC · Bolivar, MOS/N 85-0360 N1039JN1039j LLC · Casa Grande, AZBuilt 1973 · S/N 101 N1039MManly James H · Reno, NVBuilt 1998 · S/N 513 N1039PN1039p LLC · Suwanee, GABuilt 2005 · S/N 18281566 N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024 N103ACKrueger Douglas K Trustee · Aurora, NEBuilt 1992 · S/N 362-92 N103ARHd Outdoor Advs LLC · Coalgate, OKBuilt 2005 · S/N 18281663 N103ASHill Bryan Thomas · Page, AZBuilt 1979 · S/N R18200923 N103ATWjm Aviation LLC · Bridgeville, PABuilt 1970 · S/N 32-40951 N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084 N103BBHarris John F III · Louisburg, NCBuilt 2000 · S/N 2060 N103BCPalmer David M · Jacksonville, ORBuilt 2003 · S/N 448-2003 N103BHBeck Randy R · Claremont, CABuilt 2021 · S/N 3C-5C/6C-1613C N103BUColorado Aircraft Corp · Watkins, COS/N 31-7405202 N103CTSocolosky Stephen Gerard · East Hartford, CTBuilt 1973 · S/N 17253365 N103DJChicoine Chris · Williston, VTS/N 50 N103EAJwp Group LLC · Long Island, MEBuilt 1976 · S/N 32R7780054 N103ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13534 N103ENKjs Development LLC · Temecula, CABuilt 1995 · S/N 4622186 N103FVChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280553 N103GLNaylor Aviation LLC · Columbia, MOBuilt 1978 · S/N 31-7912023 N103HPMcfarland Natalie · Roseburg, ORBuilt 1965 · S/N 24-4153 N103HYLegend Flyer LLC · Bozman, MDBuilt 2003 · S/N 2241 N103KCLang Elmer N · Hemphill, TXBuilt 1979 · S/N 28-7911238 N103KFCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1999 · S/N 172S8143 N103KSKent State University · Stow, OHBuilt 2005 · S/N 172S10093 N103LULynn University Inc · Boca Raton, FLBuilt 1997 · S/N 17280298

Back to AD 2006-10-21