Skip to content

AD 2006-16-18 R1

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.

N321WMMartinez Jose A · Orlando, FLBuilt 1975 · S/N TH-571 N321WPRadmall LLC · Commerce City, COBuilt 1995 · S/N E-2929 N3220JFagen Inc · Granite Falls, MNBuilt 1995 · S/N E-2920 N3220LPee Dee Aviation LLC · Florence, SCBuilt 1995 · S/N LJ-1420 N3221MGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1621 N3222UMilpower Inc · Nampa, IDBuilt 1995 · S/N E-2919 N3222VRohsner Thomas A · Nacogdoches, TXBuilt 1947 · S/N D-800 N3223BTechmur LLC · Loudonville, NYBuilt 1995 · S/N E-2923 N3224QRech Jack R · Mohave Valley, AZBuilt 1999 · S/N E3224 N3224VHerman Ira · Albuquerque, NMBuilt 1947 · S/N D-667 N3225KWjm Aviation LLC · Friendswood, TXBuilt 1995 · S/N E-2975 N3226BSooner Aviation LLC · Norman, OKBuilt 1999 · S/N E3226 N3226JSimms Matthew · Davie, FLBuilt 1994 · S/N E-2855 N3226QDenning Aviation Inc · Fort Madison, IABuilt 2000 · S/N E-3326 N3227GOgden Scott S · Collierville, TNBuilt 1995 · S/N E-2927 N3227XSasar Inc · Wilmington, DEBuilt 1999 · S/N E-3227 N3228WChris I Lee Md Inc · Rowland Heights, CABuilt 1995 · S/N E-2928 N3228XN3228x LLC · Colusa, CABuilt 1995 · S/N E-2978 N3229GAero-Mark LLC · Winchester, KYBuilt 2000 · S/N E-3329 N322ABWilmington Trust Co Trustee · Wilmington, DES/N FL-1126 N322HGH & O Aviation LLC · Oxford, MSBuilt 1993 · S/N FL-93 N322JBJ & R Aviation Inc · Sioux Falls, SDBuilt 1990 · S/N E-2549 N322MAN322ma LLC · Reno, NVBuilt 1982 · S/N 551-0378 N322MRPf Aircraft LLC · Graham, TXBuilt 2000 · S/N LJ-1611 N322RN322r LLC · St Simons Island, GABuilt 1977 · S/N LJ-746 N322RRNion LLC · New Century, KSBuilt 1995 · S/N 514 N322SACimarron LLC · Kurten, TXBuilt 1985 · S/N TH-1488 N322SGAtlas Air Inc · Purchase, NYBuilt 2000 · S/N 30322 N322STC & W Aviation LLC · Vestavia Hills, ALBuilt 1977 · S/N 501-0278 N322VAEagle Cap Leasing Inc · Enterprise, ORBuilt 1996 · S/N 560-0399 N3232WKilgallen Keith S · Stuart, FLBuilt 1995 · S/N E-2932 N3233GMach Aviation Pilot Services LLC · Andover, KSBuilt 1995 · S/N E-2933 N3233JZebcon Inc · Russellville, ARBuilt 1999 · S/N E3233 N3233VSanchez Alfonso H · Albuquerque, NMBuilt 1947 · S/N D-676 N3235DMdb Ventures LLC · Wausau, WIBuilt 1995 · S/N E-2935 N3236GAvan LLC · Lynwood, ILS/N E-2287 N3236QBo'S Investments LLC · Amarillo, TXBuilt 1997 · S/N E3110 N3236THg Aviation LLC · Helena, MTBuilt 1995 · S/N E-2936 N3236VMlm Aviation LLC · Saint Francisville, LABuilt 1985 · S/N E-2271 N3238VAltman Michael A · Austin, TXS/N D-682 N3238YKorff Aviation LLC · Leesburg, VABuilt 1995 · S/N E-2938 N3239WHaidlen Ford Inc · Oakdale, CABuilt 1995 · S/N E-2939 N323AAE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1989 · S/N 258155 N323DBB-Air Lc · Sikeston, MOBuilt 2021 · S/N FL-1252 N323EZN323ez LLC · Amarillo, TXBuilt 1996 · S/N 525-0128 N323GBGs Aviation LLC · Lebanon, TNBuilt 1975 · S/N E-647 N323HADale Aviation Inc · Rapid City, SDBuilt 1979 · S/N LW-323 N323JRS550 LLC · Breaux Bridge, LABuilt 1987 · S/N S550-0129 N323KJohnston Darrell · Porter, TXBuilt 1982 · S/N E-1997 N323LMSandcastle Jwm Properties LLC · Paradise Valley, AZBuilt 1992 · S/N TH-1667

Back to AD 2006-16-18 R1