OpenAirDocs.org
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
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.

N275VFly Collier LLC · Naples, FLBuilt 1973 · S/N TH-376N2762VJ R Bane Land Corp · Oakland, IABuilt 1947 · S/N D-153N2764AMorse-Ellington Bruce P · Phoenix, MDBuilt 1986 · S/N E-2322N2766KTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 258744N2766VReady Aim Flyer LLC · New Castle, DEFirst renewal noticeBuilt 1947 · S/N D-157N276EBMountain Air Aviation LLC · Jonesville, VABuilt 2001 · S/N FL-335N276JBChris Allen Aviation LLC · Naples, FLBuilt 1998 · S/N FL-219N276MABank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 20800276N27722United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28789N27724United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28791N2772VCathcart Samuel H · Carlisle, OHBuilt 1947 · S/N D-164N27733United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28800N27734United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28949N2778VPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-170N277AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 62472N277ALAti Jet Inc · El Paso, TXBuilt 1984 · S/N 104N277FSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N FL-1148N277GERltwf LLC · Fiddletown, CABuilt 1990 · S/N BB-1389N277GLDiamondback Equipment Leasing LLC · Avondale, AZBuilt 1991 · S/N BB-1406N277JEAir LLC · Jasper, INBuilt 2015 · S/N FL-986N277JJHjjv LLC · Walterboro, SCBuilt 1982 · S/N BB-1043N277RSMaize & White Aviation LLC · Youngstown, OHBuilt 2004 · S/N 258693N277SPAll Systems Satellite Distributors Of Delaware LLC · Newark, DEBuilt 1980 · S/N LA-77N2785VGunnarsson Jon · Concrete, WAS/N D-177N2786VHoffner Edward M · Jefferson City, TNBuilt 1947 · S/N D-178N2787Valiair Lc Trustee · Casper, WYBuilt 1984 · S/N 257208N2787AKnudson Erik · Chandler, AZBuilt 1969 · S/N E-178N278AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 44113N278GTankersley Aviation LLC · Sylacauga, ALBuilt 1979 · S/N E-1547N278KThienes Engineering Inc · La Mirada, CABuilt 2003 · S/N 525-0527N278KWAir Rgv LLC · Mcallen, TXBuilt 2022 · S/N FL-1307N278MReid Stephen M · Gardner, KSBuilt 1980 · S/N TH-1105N278RHolliday Henry S · Poplarville, MSS/N E-1181N278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N LJ-1011N2795VBas Part Sales LLC · Greeley, COBuilt 1947 · S/N D-190N2798PNautilus Air LLC · Omaha, NEBuilt 1986 · S/N E-2337N2798VPorte Elvis · Miami, FLBuilt 1947 · S/N D-193N279CFJ Jets Inc · Dover, DES/N 258642N279PMPlanemasters Ltd · West Chicago, ILBuilt 1997 · S/N 208B0623N27BNTravelaire Service Inc · Wilmington, DES/N BB-1268N27CJ411kc LLC · Tuscaloosa, ALBuilt 1999 · S/N 525-0311N27DQOhio University · Albany, OHBuilt 1972 · S/N TH-228N27EWTextron Aviation Inc · Wichita, KSS/N 525-1425N27HBBalk Christopher T · Arlington, WABuilt 1977 · S/N E-999N27LHStavros Andrew · San Jose, CABuilt 1972 · S/N E-375N27MGAvion Capital Corp · Anchorage, AKBuilt 1997 · S/N 208B0650N27MTFlying Dog Aviation LLC · Swanton, OHBuilt 1980 · S/N TH1120N27PKOgary Aviation LLC · North Little Rock, ARBuilt 1993 · S/N TH-1687N27RCCoastal Holding LLC · Holland, MIBuilt 1983 · S/N BB-1134N27THood David · Odessa, TXBuilt 1980 · S/N E-1783
Back to AD 2006-16-18 R1