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.

N74GZ921be LLC · Clarksdale, MSBuilt 1985 · S/N S550-0074N74HREscape Aviation LLC · Houston, TXBuilt 1984 · S/N 5010677N74KMCyd Aviation LLC · Austin, TXBuilt 2014 · S/N 525-0800N74KSR & R Pallet Of Garden City · Garden City, KSBuilt 2000 · S/N FL-299N74NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2016 · S/N FL-1053N74RARoyal Air Freight Inc · Waterford, MIBuilt 2004 · S/N BB-1869N74SCGreen Michael B · Kent, WAS/N D-432N74TFTripifoods Inc · Buffalo, NYS/N FL-370N74TGLf Operations LLC N74tg Series · Coalgate, OKBuilt 1968 · S/N E-3N74USTwo Three Air LLC · Orlando, FLBuilt 1974 · S/N E-574N74WJVicari Aviation LLC · Harvey, LABuilt 1988 · S/N E-2458N74WMTurnage Leon G · Weatherford, TXBuilt 1975 · S/N TH-653N75Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-10N7500NReiter Ken · Plano, TXBuilt 1968 · S/N E-41N7501NBeckner Gregory · Houston, TXBuilt 1968 · S/N E-42N7504NReynolds Rex J · Bloomington, INBuilt 1968 · S/N E-37N7505NMiller Mary Lou · Dothan, ALBuilt 1968 · S/N E-36N750BBJjs3 LLC · Baton Rouge, LABuilt 1983 · S/N BB-1169N750CKMn Aircraft LLC · San Juan, PRBuilt 1992 · S/N 650-7015N750FDFederal Express Corp · Memphis, TNBuilt 1990 · S/N 555N750FLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 560-0268N750FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0511N750JMTailwinds II LLC · Houston, TXBuilt 1985 · S/N S550-0045N750KAN750ka LLC · Wilmington, DEBuilt 1977 · S/N BB224N750KPAircraft Structures International Corp · Enid, OKBuilt 1997 · S/N 208B0628N750MLLincoln Industries Inc · Lincoln, NEBuilt 1994 · S/N 560-0247N750RCLuke & Payton LLC · Marianna, ARS/N LJ-640N750RVWright Air Service Inc · Fairbanks, AKBuilt 2015 · S/N 208B5194N750TTDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N BB215N750ZSouthern Airways Pacific LLC · Addison, TXBuilt 2004 · S/N 208B1054N7513NAspiras Dionisio O Jr · Rosharon, TXBuilt 1968 · S/N E-47N751FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 625N751FEFederal Express Corp · Memphis, TNBuilt 1990 · S/N 208B0245N751FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0514N751KCJ A Peterson Enterprises Inc · Shawnee Mission, KSBuilt 1980 · S/N LJ-887N751LScience And Engineering Services LLC · Huntsville, ALS/N FL-1329N751PPPlane White Corporation · Sunriver, ORBuilt 1999 · S/N E3260N7523NSickels Henry C · El Cajon, CABuilt 1968 · S/N E-49N7525NFityfityink LLC · Troy, OHBuilt 1968 · S/N E-52N7526NJr Aircraft LLC · Lexington, KYBuilt 1968 · S/N E-53N7527NParadise Prop LLC · Cedarburg, WIBuilt 1968 · S/N E-54N752DHKalitta Charters II LLC · Ypsilanti, MIBuilt 1981 · S/N 22466N752FEFederal Express Corporation · Memphis, TNBuilt 1990 · S/N 208B0247N752FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0517N753AFTwin Otter International Ltd · Las Vegas, NVS/N 206N753BABering Air Inc · Nome, AKBuilt 2024 · S/N 208B5798N753DMAcid And Cementing Inc · Palestine, TXBuilt 2002 · S/N TH-2047N753FXFederal Express Corporation · Memphis, TNBuilt 1996 · S/N 208B0520N753GJWarhawk Aviation LLC · Baton Rouge, LABuilt 1995 · S/N 560-0306N753KPKalinin Partners LLC · Juneau, AKBuilt 2007 · S/N 208B1275
Back to AD 2006-16-18 R1