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.

N625WAPhoenix Helicopters LLC · Dover, DEBuilt 1989 · S/N 560-0027 N6261KGlasmon Inc · Nacogdoches, TXBuilt 1981 · S/N E-1993 N6266NSai Flight Services Inc · Greer, SCBuilt 1982 · S/N E-2001 N6266XWells & West Inc · Murphy, NCBuilt 1962 · S/N 500A-1141-61 N626ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30793 N626CRSmiles Aviation LLC · Kerrville, TXBuilt 1978 · S/N E-1367 N626CVCvi Aircraft Leasing LLC · Coldwater, MIBuilt 2006 · S/N 525-0626 N626DRK And L Transportation LLC · Carterville, ILFirst renewal noticeS/N 421C0512 N626DSBoeing Co · Renton, WABuilt 2025 · S/N 68738 N626LMOne Percent Aviation LLC · Lewes, DES/N 208B-0694 N626PRai Aviation LLC · Athens, GAS/N E-3552 N626RBMillard Robert B · Stratford, CTBuilt 1993 · S/N 560-0221 N626RMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2017 · S/N 525-0969 N626TMJj'S Jet LLC · Zanesville, OHBuilt 1999 · S/N 525-0307 N6271RAir Jag LLC · Garden City, KSBuilt 1982 · S/N TH-1331 N627ASAlaska Airlines Inc · Seattle, WABuilt 2001 · S/N 30794 N627EMMinton Air LLC · Alexandria, VABuilt 2025 · S/N 20800716 N627GBRose Isle Aviation LLC · Orlando, FLBuilt 2016 · S/N 525-0930 N627KMSpectre Aviation LLC · Dover, DES/N BE-93 N627MGMile High Adventures LLC · Yazoo City, MSBuilt 1989 · S/N FA-197 N627MW627mw LLC · Wilmington, DEBuilt 2006 · S/N 525-0627 N6283NValiair Lc Trustee · Casper, WYBuilt 1982 · S/N E-2002 N62849United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42204 N6284UBonanza Group LLC · Phoenix, AZBuilt 1982 · S/N E-2003 N62854High Flight Connections LLC · Roanoke, INBuilt 1982 · S/N E-2008 N6285NMoon Dipper Aviation LLC · Deerfield Beach, FLBuilt 1982 · S/N E-2005 N6285XSpires William A · Columbus, GABuilt 1982 · S/N E-2006 N6287XWallen Joe · Knoxville, TNS/N 500A-1250-75 N62883United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42202 N62884United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42203 N62889United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42193 N62892United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42195 N62894United Airlines Inc · Chicago, ILBuilt 2016 · S/N 42198 N62895United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62769 N62896United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62768 N628AKBaron Partners LLC · Bessemer, ALS/N TH-1614 N628EKKauffman Land & Development LLC · Fort Lupton, COBuilt 1982 · S/N 071 N628MDClarkton Aviation III LLC · Clarkton, MOBuilt 1992 · S/N TH-1662 N628TMFedair LLC · Indianapolis, INBuilt 1993 · S/N 525-0010 N6292ZBlv Aviation LLC · Columbus, INBuilt 1982 · S/N E-2010 N6296XDye Michael M · Bastrop, TXBuilt 1962 · S/N 500A-1254-78 N6297LMccaskill Justin E · Montgomery, TXBuilt 1982 · S/N E-2012 N6298XN111es Inc · Monticello, INS/N E-2013 N6299XSouth Florida Exotics LLC · Missoula, MTBuilt 1982 · S/N E-2016 N629BEWbme LLC · Warrenville, SCBuilt 1999 · S/N E-3287 N629CJEssex Aircraft Management LLC · Randolph, NJS/N TH-2104 N629EBRuff Cattle Co · Hanston, KSBuilt 1997 · S/N E-3085 N629FFAllen Teinert Construction Co · Lubbock, TXBuilt 1998 · S/N 560-0490 N629MDAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1985 · S/N 650-0096 N629PGOrial Floyd · Evans, GABuilt 2004 · S/N E-3550

Back to AD 2006-16-18 R1